Received: from smtpout.mac.com (smtpout.mac.com [204.179.120.88]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9V97IP57983 for ; Wed, 31 Oct 2001 04:07:18 -0500 (EST) (envelope-from steph_chomat@mac.com) Received: from smtp-relay01.mac.com (smtp-relay01-qfe3 [10.13.10.224]) by smtpout.mac.com (8.10.2/8.10.2/1.0) with ESMTP id f9V969Y20017 for ; Wed, 31 Oct 2001 01:06:09 -0800 (PST) Received: from asmtp02.mac.com ([10.13.10.66]) by smtp-relay01.mac.com (Netscape Messaging Server 4.15 relay01 Jun 21 2001 23:53:48) with ESMTP id GM2BZZ00.MQJ for ; Wed, 31 Oct 2001 01:07:11 -0800 Received: from localhost ([217.128.128.146]) by asmtp02.mac.com (Netscape Messaging Server 4.15 asmtp02 Jun 21 2001 23:53:48) with ESMTP id GM2BZY00.NEB for ; Wed, 31 Oct 2001 01:07:10 -0800 Date: Wed, 31 Oct 2001 10:06:22 +0100 Mime-Version: 1.0 (Apple Message framework v472) Content-Type: multipart/alternative; boundary=Apple-Mail-2-442178306 Subject: Primary key with oid + name : error, which solution ? From: =?ISO-8859-1?Q?St=E9phane_Chomat?= To: pgsql-sql@postgresql.org Message-Id: <8DADA046-CDDE-11D5-A73B-003065C28650@mac.com> X-Mailer: Apple Mail (2.472) X-Archive-Number: 200110/426 X-Sequence-Number: 5377 --Apple-Mail-2-442178306 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=ISO-8859-1; format=flowed I create two table repertory and person. And i have an error : > CREATE TABLE repertory (name_rep name, attribut text[], PRIMARY=20 KEY(name_rep)); > CREATE TABLE person (nam_rep repertory, name_pers text, url text, eadr= =20 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=E9phane Chomat 22 rue Le Brix 38100 Grenoble 603-999-478 steph_chomat@mac.com --Apple-Mail-2-442178306 Content-Transfer-Encoding: quoted-printable Content-Type: text/enriched; charset=ISO-8859-1 I create two table repertory and person. And i have an error : =20 > 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=E9phane Chomat 22 rue Le Brix 38100 Grenoble 603-999-478 steph_chomat@mac.com --Apple-Mail-2-442178306--