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

I tried to reproduce this, but it works for me ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to