Re: Getting FK relationships from information_schema

Kyle <kyle@actarg.com> writes:
> I think this is only an issue when the user relies on postgres to choose 
> a constraint name automatically.  Seems like a reasonable approach would 
> be to have postgres choose a name for the constraint that happens to be 
> unique in the schema (like tablename_fkey_$1).

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?

(Of course, this is only a long-term fix for your original problem,
as it'll take a good long while for any such naming change to propagate
to Joe's-Corner-Bar's database.)
        regards, tom lane