Re: Getting FK relationships from information_schema - Mailing list pgsql-sql

From Tom Lane
Subject Re: Getting FK relationships from information_schema
Date
Msg-id 20685.1086849134@sss.pgh.pa.us
Whole thread Raw
In response to Re: Getting FK relationships from information_schema  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane wrote:
>> We have discussed changing the default names of FK constraints
>> before. I have no problem with doing something like the above --- any
>> objection out there?

> I think it's a good idea.  It will also make the error messages of the 
> kind "foreign key $1 violated" a bit clearer by default.

Right ho --- I'm working on a patch that will choose default names
of the form table_column_checkN and table_column_fkeyN, similar to
what we already do for index constraints.
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Schema + User-Defined Data Type Indexing problems...
Next
From: Martin Schäfer
Date:
Subject: Find out whether a view's column is indexed?