Re: [SQL] information_schema.referential_constraints permissions

2008-04-28 Thread Tom Lane
"Lodewijk Voege" <[EMAIL PROTECTED]> writes: > I have some code that gets foreign key information from > information_schema.referential_constraints. I was puzzled about why it wasn't > returning anything for a while, until I read the information_schema.sql file > and the documentation carefully: it

[SQL] information_schema.referential_constraints permissions

2008-04-28 Thread Lodewijk Voege
hello, I have some code that gets foreign key information from information_schema.referential_constraints. I was puzzled about why it wasn't returning anything for a while, until I read the information_schema.sql file and the documentation carefully: it has a pg_has_role(c.relowner, 'USAGE') in it