From: Rosser Schwarz <rosser.schwarz@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: function fails where individual statements succeed
Date: Mon, 30 Aug 2004 15:40:23 -0500
Message-ID: <37d451f704083013401926a341@mail.gmail.com> (raw)
In-Reply-To: <11133.1093897977@sss.pgh.pa.us>
References: <37d451f7040830101763682930@mail.gmail.com>
<11133.1093897977@sss.pgh.pa.us>
while you weren't looking, Tom Lane wrote:
[...]
> If you want to encapsulate this set of operations in a function, I'd
> suggest using plpgsql and being careful to EXECUTE each query rather
> than letting plpgsql try to cache a plan for it.
We've opted to simply script issuing the statements serially, rather
than as a function for this one. Your explanation makes sense, Tom,
though I'm curious why it works in our long-running case (beyond the
issue of fewer indices there). Given that, I'm going to move that we
adopt the serial issuance approach for that process, to save off the
error eventually cropping up there, too.
Dankeschoen,
/rls
--
:wq
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-sql@postgresql.org
Cc: rosser.schwarz@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: function fails where individual statements succeed
In-Reply-To: <37d451f704083013401926a341@mail.gmail.com>
* 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