Primary key with oid + name : error, which solution ? - Mailing list pgsql-sql

From Stéphane Chomat
Subject Primary key with oid + name : error, which solution ?
Date
Msg-id 8DADA046-CDDE-11D5-A73B-003065C28650@mac.com
Whole thread Raw
Responses Re: Primary key with oid + name : error, which solution ?  (Roberto Mello <rmello@cc.usu.edu>)
Re: Primary key with oid + name : error, which solution ?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
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 ?


<flushright><bold><bigger>Stéphane Chomat</bigger></bold>

22 rue Le Brix

38100 Grenoble

603-999-478

steph_chomat@mac.com</flushright>

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange loop
Next
From: jeremy@wundt.psychiatry.uiowa.edu (H Jeremy Bockholt)
Date:
Subject: transposing data for a view