On Wed, 31 Oct 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(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 ?
You'd probably be best off using the name of the repertory in the person table along with a foreign key. Also, IIRC name is mostly meant as an internal type. You probably really want varchar(<length>). ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
