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_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".
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
