From: | dba <dbadbb(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | setting foreigh key for an array. |
Date: | 2011-02-14 10:56:21 |
Message-ID: | 1297680981226-3384263.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have a requirement.
Created table called a.
CREATE TABLE a(no int primary key,name text);
Need to create reference key for no field of array. which is belongs to b
table.
The postgresql is not allowing to create a reference for incompatible type.
CREATE TABLE d(no int[] references a,name text);
ERROR: foreign key constraint "d_no_fkey" cannot be implemented
DETAIL: Key columns "no" and "no" are of incompatible types: integer[] and
integer.
Is there any solution to setting foreign key for an array.
NOTE:
Kindly ensure that I don't want to change the int to int[] in a
table.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/setting-foreigh-key-for-an-array-tp3384263p3384263.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | dba | 2011-02-14 10:56:24 | setting foreigh key for an array. |
Previous Message | Stuart Bishop | 2011-02-14 10:07:36 | Re: Postgres on NAS/NFS |