Re: Programmatic Trigger Create

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Niko Ware <nikowareinc(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Programmatic Trigger Create
Date: 2021-03-20 17:23:21
Message-ID: 228721.1616261001@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2021-03-20 19:01:05 Re: More than one UNIQUE key when matching items..
Previous Message Adrian Klaver 2021-03-20 17:13:50 Re: Programmatic Trigger Create