[SQL] Primary key with oid + name : error, which solution ?

[Stéphane Chomat]

I create two table repertory and person. And i have an error :


> CREATE TABLE repertory (name_rep name, attribut text[], PRIMARY KEY(name_rep));
> CREATE TABLE person (nam_rep repertory, name_pers text, url text, eadr text, tel text, attribut text[], PRIMARY KEY(name_pers,nam_rep));

NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'person_pkey' for table 'person'
ERROR: DefineIndex: type repertory has no default operator class

which solution for this problem ?

Stéphane Chomat
22 rue Le Brix
38100 Grenoble
603-999-478
[EMAIL PROTECTED]