Adrian Klaver <adrian.klaver@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