From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: brandystodd@gmail.com, PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #18647: INSERT statements execute functions twice.
Date: Tue, 08 Oct 2024 16:24:07 -0400
Message-ID: <2246127.1728419047@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwYYJD5bw-h_cASQRBHUnN2CMCo=nOpxgqKoNFALLpukWA@mail.gmail.com>
References: <18647-8ac606f2f23b1621@postgresql.org>
<CAKFQuwYYJD5bw-h_cASQRBHUnN2CMCo=nOpxgqKoNFALLpukWA@mail.gmail.com>
"David G. Johnston" <david.g.johnston@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18647: INSERT statements execute functions twice.
In-Reply-To: <2246127.1728419047@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox