BUG #2848: information_schema.key_column_usage does not work

From: "Tony Marston" <tony(at)marston-home(dot)demon(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2848: information_schema.key_column_usage does not work
Date: 2006-12-21 11:28:40
Message-ID: 200612211128.kBLBSevQ099900@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2848
Logged by: Tony Marston
Email address: tony(at)marston-home(dot)demon(dot)co(dot)uk
PostgreSQL version: 8.2
Operating system: Windows XP
Description: information_schema.key_column_usage does not work
Details:

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 table_name='whatever'
ORDER BY constraint_type, constraint_name, ordinal_position

This works when I am logged on as 'postgres', but if I try it after logging
on with a different username it fails with "ERROR: relation with OID 18635
does not exist".

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gurjeet Singh 2006-12-21 11:43:44 BUG #2849: Erroronous UPDATE syntax in documentation
Previous Message Sandip G 2006-12-21 07:41:33 NEED URGENT HELP....