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

2001-10-31 Thread Stéphane Chomat
2001, [ISO-8859-1] Stéphane Chomat wrote: 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

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

2001-10-31 Thread Stéphane Chomat
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]