Re: BUG #18647: INSERT statements execute functions twice.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: brandystodd(at)gmail(dot)com, PostgreSQL Bug List <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #18647: INSERT statements execute functions twice.
Date: 2024-10-08 20:24:07
Message-ID: 2246127.1728419047@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> The create table for party probably helps too.

I'm wondering about ON INSERT rules for that table ...

> IOW, make it possible for someone to reproduce your issue.

Indeed. I tried some simple experiments with setting a breakpoint
on the standard nextval() function, and I don't see more than one
call.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-10-09 00:54:06 BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
Previous Message David G. Johnston 2024-10-08 20:04:17 Re: BUG #18647: INSERT statements execute functions twice.