Arrays and foreign keys
От | Kaare Rasmussen |
---|---|
Тема | Arrays and foreign keys |
Дата | |
Msg-id | 00080822074400.00770@bering обсуждение исходный текст |
Ответы |
Re: Arrays and foreign keys
|
Список | pgsql-hackers |
Seems that it's not possible to combine arrays and foreign keys ? CREATE TABLE table1 ( fld1 integer NOT NULL, number integer, level integer,PRIMARYKEY (fld1) ); CREATE TABLE table2 ( pkey integer NOT NULL, arvar integer[],PRIMARY KEY (pkey),FOREIGNKEY (arvar) REFERENCES table1(fld1) ); This works, but the following insert complains that ERROR: Unable to identify an operator '=' for types 'int4' and '_int4' You will have to retype this query using anexplicit cast -- Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582 Kaki Data tshirts, merchandize Fax: 3816 2582 Howitzvej 75 �ben 14.00-18.00 Email: kar@webline.dk 2000 Frederiksberg L�rdag 11.00-17.00 Web: www.suse.dk
В списке pgsql-hackers по дате отправления: