From: Rosser Schwarz <rosser.schwarz@gmail.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: function fails where individual statements succeed
Date: Mon, 30 Aug 2004 13:34:23 -0500
Message-ID: <37d451f704083011341f51cdaa@mail.gmail.com> (raw)
In-Reply-To: <200408301048.49436.josh@agliodbs.com>
References: <37d451f7040830101763682930@mail.gmail.com>
<200408301048.49436.josh@agliodbs.com>
while you weren't looking, Josh Berkus wrote:
> Statement 14 should be that one. Can you test it, and the statements
> immediately preccedeing and succeeding it on the command line again?
Just running the CREATE INDEXes (after issuing the appropriate DROPs,
of course) succeeds.
> Also, can you try the whole run without the COPY statement? I'm curious to
> see if something in the COPY file is messing things up.
Running without the COPY yields a substantively similar error message.
Again, this error only happens when the statements are executed in the
context of a function; outside, even issued all at once separated by
semicolons, the behavior is correct.
I was just reminded that there is another difference between this
function and the working one: this one is rather more heavily indexed.
(None of the compound, conditional indices exist in the earlier,
working version.) That might point in the direction of the error,
though it doesn't explain why it only fails in a function; I'll do
some digging.
/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, josh@agliodbs.com
Subject: Re: function fails where individual statements succeed
In-Reply-To: <37d451f704083011341f51cdaa@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