"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