Silent failure of an INSERT

I created a Python program that runs an INSERT command via PpyPgSQL. It
returns a result of NONE and triggers no exception, but no row is added.
I grab the query that is being run and I run it directly from a Pgsql
client and it works fine.

Thoughts: I am using pyPgSQL-2.4 and built and installed it while we
were using postgress 7.3. Recently we upgraded to postgress 7.4, but I
did not rebuild or reinstall pyPgSQL. My code, which uses tons of
queries, never blinked due to the upgrade.

Perhaps I need to rebuild in order to get INSERT to work. (Another
possibility is that the build was funky and INSERT never did work and I
am only finding that out now.)

Any thoughts on any of this?

Rock




-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click