Re: [GENERAL] best way to get PKey and FKey from inside applications (permission pb)

2006-06-22 Thread Tom Lane
[EMAIL PROTECTED] writes: > SQL2003 fixes these issues with information_schema but it seems that > postgres has not caught up yet: > http://groups.google.com/group/pgsql.interfaces/browse_thread/thread/9f19995849b3cdf4/c20b81bf8cf183af?lnk=st&q=information+schema&rnum=9&hl=en#c20b81bf8cf183af I be

Re: [GENERAL] best way to get PKey and FKey from inside applications (permission pb)

2006-06-22 Thread zzzeek
sandro - SQL2003 fixes these issues with information_schema but it seems that postgres has not caught up yet: http://groups.google.com/group/pgsql.interfaces/browse_thread/thread/9f19995849b3cdf4/c20b81bf8cf183af?lnk=st&q=information+schema&rnum=9&hl=en#c20b81bf8cf183af although i am running only

[GENERAL] best way to get PKey and FKey from inside applications (permission pb)

2006-06-20 Thread Sandro Dentella
Hi all, I started using sqlalchemy (python ORM) that works really well but fails detecting Primary and Foreign key other than for owner or superusers. Sqlalchemy queries the information schema with the following query that returns nothing if you are connected as a user with no particular privilege