Re: [Zope] PoPy and system tables

2000-11-27 Thread Federico Di Gregorio
> can anybody out there tell me why this query fails > although PoPyDA is connected as postgres superuser ? > > select * from pg_class at now popy tries to dereference every oid thinking it is a large object. obviously that is not tru for oids of system tables... *grin* hope this helps, federi

Re: [Zope] PoPy and system tables

2000-11-26 Thread Andreas
Chris Gray wrote: > > I can pinpoint the problem a bit more. > > select > relname, relowner, relpages, reltuples, relhasindex, relisshared, relkind, > relnatts, relchecks, reltriggers, relukeys, relfkeys, relrefs, relhaspkey, > relhasrules, relacl > from pg_class > > works fine but > > select

Re: [Zope] PoPy and system tables

2000-11-25 Thread Chris Gray
I can pinpoint the problem a bit more. select relname, relowner, relpages, reltuples, relhasindex, relisshared, relkind, relnatts, relchecks, reltriggers, relukeys, relfkeys, relrefs, relhaspkey, relhasrules, relacl from pg_class works fine but select reltype from pg_class select relam from pg

Re: [Zope] PoPy and system tables

2000-11-25 Thread Andreas
Andreas wrote: > > Hi, > can anybody out there tell me why this query fails > although PoPyDA is connected as postgres superuser ? > > select * from pg_class by now I found there is a problem with pg_class.oid. "select relname from pg_class" works fine "select oid from pg_class" fails -- ___

[Zope] PoPy and system tables

2000-11-25 Thread Andreas
Hi, can anybody out there tell me why this query fails although PoPyDA is connected as postgres superuser ? select * from pg_class BTW: when I try this query I get no traceback :-( Postgres 7.02 PoPy 1.4.1 ZPoPyDA 0.7 Zope2.1.6 Linux 2.2.13 -- ___