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 по дате отправления: