Re: Information Schema and constraint names not unique

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Information Schema and constraint names not unique
Date: 2003-11-07 16:14:11
Message-ID: 3FABC4D3.6040409@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

>Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>
>
>
>>. add tableoid or tablename to information_schema.{check_constraints,
>>referential_constraints} (I think those are the only places where it
>>would be needed, from my quick skimming).
>>. add tableoid or tablename to autogenerated table constraint names
>>
>>
>
>These are mutually exclusive --- I see no reason to do both.
>
>
>

In that case I vote for option 2 - it makes the names nicer and gets us
closer to compliance with the spec.

:-)

(Option 1 is trivially easy by comparison, though).

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2003-11-07 16:14:35 Re: Experimental ARC implementation
Previous Message Christopher Browne 2003-11-07 16:12:28 Re: [HACKERS] Changes to Contributor List