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".
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.... |