Re: Information Schema and constraint names not unique - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Information Schema and constraint names not unique
Date
Msg-id 20350.1068136933@sss.pgh.pa.us
Whole thread Raw
In response to Re: Information Schema and constraint names not unique  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Information Schema and constraint names not unique
Re: Information Schema and constraint names not unique
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> I don't think we really need a method to guarantee unique names.  It would
> already help a lot if we just added the table name, or something that was
> until a short time before the action believed to be the table name, or
> even only the table OID, before (or after) the $1.

I don't have a problem with switching from "$1" to "tablename_$1", or
some such, for auto-generated constraint names.  But if it's not
guaranteed unique, does it really satisfy Philip's concern?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Information Schema and constraint names not unique
Next
From: Josh Berkus
Date:
Subject: Re: Changes to Contributor List