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

From: Stéphane Chomat <steph_chomat(at)mac(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Primary key with oid + name : error, which solution ?
Date: 2001-10-31 09:06:22
Message-ID: 8DADA046-CDDE-11D5-A73B-003065C28650@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Stéphane Chomat
22 rue Le Brix
38100 Grenoble
603-999-478
steph_chomat(at)mac(dot)com

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message H Jeremy Bockholt 2001-10-31 18:27:47 Re: transposing data for a view
Previous Message Arian Prins 2001-10-31 07:51:36 Re: transposing data for a view