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