PoPy and system tables
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 -- _________________________________________________________ Andreas Heckel andreas@aHIT.de
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 -- ________________________________________________________________________ Andreas Heckel andreas@aHIT.de Linux is like a wigwam ...no gates ...no windows and an apache inside ;-)
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_class select rellongrelid from pg_class all cause problems and sometimes crash my instance of Zope! These three fields all have the type oid. Apparently PoPy can't handle returned values of this type. Chris On Sun, 26 Nov 2000, Andreas wrote:
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
-- _________________________________________________________ Andreas Heckel andreas@aHIT.de
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
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 reltype from pg_class select relam from pg_class select rellongrelid from pg_class
all cause problems and sometimes crash my instance of Zope! These three fields all have the type oid. Apparently PoPy can't handle returned values of this type.
PoPyDA has serious problems with oid fields. But I found a temporary solution. select int4(relam) from pg_class -- ________________________________________________________________________ Andreas Heckel andreas@aHIT.de UNIX is like a wigwam ...no gates ...no windows and an apache inside ;-)
participants (2)
-
Andreas -
Chris Gray