Re: function fails where individual statements succeed - Mailing list pgsql-sql

From Tom Lane
Subject Re: function fails where individual statements succeed
Date
Msg-id 11478.1093899801@sss.pgh.pa.us
Whole thread Raw
In response to Re: function fails where individual statements succeed  (Rosser Schwarz <rosser.schwarz@gmail.com>)
Responses Re: function fails where individual statements succeed  (Rosser Schwarz <rosser.schwarz@gmail.com>)
List pgsql-sql
Rosser Schwarz <rosser.schwarz@gmail.com> writes:
> 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).

Does the other case have any partial indexes?  The particular error
was about an index predicate condition; it might be that you don't
happen to fall foul of the issue when dealing with simple CREATE
INDEX commands.  I'd describe that as "miraculously managing not to
fail", though, not as a behavior I'd care to rely on.
        regards, tom lane


pgsql-sql by date:

Previous
From: Rosser Schwarz
Date:
Subject: Re: function fails where individual statements succeed
Next
From: Rosser Schwarz
Date:
Subject: Re: function fails where individual statements succeed