[PyGreSQL] callproc() and Stored Procedures

Christoph Zwerschke cito at online.de
Fri Feb 29 21:20:31 EST 2008


Daryl Tester schrieb:
> This looks like pgdb (which I rarely use). I had a quick look at the
> pgdbCursor class and doesn't appear to be any callproc() methods, so
> the attribute error is accurate.  Perhaps you meant
> fetchone()/fetchall()/fetchmany()?

Yes, it is not implemented in PyGreSQL, which is ok since the DBAPI says 
this is optional. Also (correct me if I'm wrong) in PostgreSQL 
everything is a function, there is no distinction between procedures and 
functions. So you can do the same "SELECT" trick with pgdb, using 
execute() instead of query().

-- Christoph


More information about the PyGreSQL mailing list