[Pypgsql-users] Silent failure of an INSERT

[Rock H. <ro...@ip...>]

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