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

Yes, name is an internal type. The problem is in the type of the table
repertory. If it is not

possible to use this syntaxe, i will take the type char. I just try
the new possibility of postgressql.

thanks.

steph.



Le mercredi 31 octobre 2001, à 11:08 , Stephan Szabo a écrit :


<excerpt>On Wed, 31 Oct 2001, [ISO-8859-1] Stéphane Chomat wrote:


<excerpt>I create two table repertory and person. And i have an error :


<excerpt>CREATE TABLE repertory (name_rep name, attribut text[],
PRIMARY

</excerpt>KEY(name_rep));

<excerpt>CREATE TABLE person (nam_rep repertory, name_pers text, url
text, eadr

</excerpt>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 ?

</excerpt>

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>).



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

22 rue Le Brix

38100 Grenoble

603-999-478

steph_chomat@mac.com</flushright>