Josh Berkus <j...@agliodbs.com> writes:
> By information_schema, you wouldn't have any idea that errors_file_fkey 
> is defined on the table Errors, let alone what columns it's defined 
> against.

Look into key_column_usage.

> I'm happy to write some code to fix it, if we can agree what these views 
> should show.  I think constraint_column_usage and constraint_table_usage 
> should be showing the data of both the referenced and referencing tables.

You might think that, but the specification is 100% clear that you're
wrong.

                        regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to