The use of arrays as foreign key

Поиск
Список
Период
Сортировка
От Mourad EL HADJ MIMOUNE
Тема The use of arrays as foreign key
Дата
Msg-id 006801c171d7$df496100$71a337c1@ensma.fr
обсуждение исходный текст
Ответ на SSL Connection via odbc  (Fernando San Martín Woerner <snmartin@galilea.cl>)
Ответы Re: The use of arrays as foreign key  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hi,
I'am trying to use  foreign key constraint on column of type  int[] (
array ) without success.
Exemple:

Create table course (id serial, name varchar);
Create table student (id serial, name varchar, course int[3], Constraint
f_key Foreign key (course) references course (id));

plib_gene=# insert into course (name) values ('math');
INSERT 600730 1
plib_gene=# insert into course (name) values ('info');
INSERT 600731 1
plib_gene=# insert into course (name) values ('phys');
INSERT 600732 1
plib_gene=# insert into course (name) values ('chimie');
INSERT 600733 1
plib_gene=# insert into course (name) values ('sport');
INSERT 600734 1
plib_gene=# insert into student (name, course) values ('mourad', '{1,2,3}');
ERROR:  Unable to identify an operator '=' for types 'int4' and '_int4'
You will have to retype this query using an explicit cast

I have installed a new operators on array types by using  functions from the
contrib/array directory  of postgresql source.
But I obtained the same error message.

Why we can't use OID as a foreign key?
What this the utility of OIDVECTOR?
Thanks for your help.
Mourad.


В списке pgsql-general по дате отправления:

Предыдущее
От: Tommi Mäkitalo
Дата:
Сообщение: Re: anyone knows about pam_pgsql ?
Следующее
От: Fernando San Martín Woerner
Дата:
Сообщение: RV: SSL Connection via odbc