AW: Constraint names using 'user namespace'? - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Constraint names using 'user namespace'?
Date
Msg-id 11C1E6749A55D411A9670001FA68796336814C@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> > pjw=# create table pk1(f1 integer, constraint zzz primary key(f1));
> > NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit 
> index 'zzz' for
> > table 'pk1'
> > CREATE
> > pjw=# create table zzz(f1 integer);
> > ERROR:  Relation 'zzz' already exists
> 
> > Is there a good reason why the automatically created items 
> do not have a
> > 'pg_' in front of their names?
> 
> Not a good idea.  I think it should probably be pk1_zzz in this case.
> 
> If we do either, it will break the recently submitted pg_dump 
> patch that
> uses the index name as the constraint name.  I thought that patch was
> wrongheaded anyway, and would recommend reversing it...

I rather think, that having index names clash with table names is the bogus part.
That the index gets the specified name from the constraint clause is more
or less expected behavior (Informix, Oracle  ...).

Andreas


pgsql-hackers by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Patch for 7.0.3 code to read pg_options
Next
From: Thomas Lockhart
Date:
Subject: Re: is it a bug?