Re: [BUGS] BUG #2848: information_schema.key_column_usage does not work

2007-01-16 Thread Tom Lane
Laurence Rowe <[EMAIL PROTECTED]> writes: >> I have the following query: >> >> SELECT key_column_usage.*,constraint_type >> FROM information_schema.key_column_usage >> LEFT JOIN information_schema.table_constraints USING >> (table_schema,table_name,constraint_name) >> WHERE table_schema='whatev

Re: [BUGS] BUG #2848: information_schema.key_column_usage does not work

2007-01-16 Thread Laurence Rowe
I see the same problem with 8.2 on linux. Laurence Tony Marston wrote: The following bug has been logged online: Bug reference: 2848 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:information

Re: [BUGS] BUG #2848: information_schema.key_column_usage does not work

2006-12-21 Thread Tom Lane
"Tony Marston" <[EMAIL PROTECTED]> writes: > I have the following query: > SELECT key_column_usage.*,constraint_type > FROM information_schema.key_column_usage > LEFT JOIN information_schema.table_constraints USING > (table_schema,table_name,constraint_name) > WHERE table_schema='whatever' and

[BUGS] BUG #2848: information_schema.key_column_usage does not work

2006-12-21 Thread Tony Marston
The following bug has been logged online: Bug reference: 2848 Logged by: Tony Marston Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:information_schema.key_column_usage does not work Details: I have the following qu