Adrian Klaver <adrian.kla...@aklaver.com> writes: > In what program is: > EXEC SQL EXECUTE IMMEDIATE :my_sql_cmd > being done?
Presumably ECPG, which if memory serves defaults to not-auto-commit.
Maybe Niko is failing to commit the transaction?
If all else fails, turning on log_statements on the server and
examining the log might help debug what the program is doing wrong.
regards, tom lane
