Re: function fails where individual statements succeed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: function fails where individual statements succeed
Date: 2004-08-30 21:03:21
Message-ID: 11478.1093899801@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rosser Schwarz 2004-08-30 22:12:35 Re: function fails where individual statements succeed
Previous Message Rosser Schwarz 2004-08-30 20:40:23 Re: function fails where individual statements succeed