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

From Andrew Dunstan
Subject Re: Information Schema and constraint names not unique
Date
Msg-id 3FABC4D3.6040409@dunslane.net
Whole thread Raw
In response to Re: Information Schema and constraint names not unique  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

>Andrew Dunstan <andrew@dunslane.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



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Experimental ARC implementation
Next
From: Jan Wieck
Date:
Subject: Re: Experimental ARC implementation