Re: Odd error message - Mailing list pgsql-general

From Richard Huxton
Subject Re: Odd error message
Date
Msg-id 200306161045.41963.dev@archonet.com
Whole thread Raw
In response to Odd error message  (nolan@celery.tssi.com)
List pgsql-general
On Sunday 15 Jun 2003 9:41 pm, nolan@celery.tssi.com wrote:
[snip]
> It didn't, so I dropped
> that index and created a different one, adding a third column to the index.
>
> I then got the following error message:
>
> WARNING:  Error occurred while executing PL/pgSQL function uscf_status_on
> WARNING:  line 8 at select into variables
> ERROR:  Relation 3912941 does not exist
>
> Recreating the function got rid of the error message, though I didn't
> get the performance improvement I was looking for.

PL/pgsql functions are "compiled" on their first call and plans are fixed at
this time. So - if a plan relies on something you delete there are problems.
I tend to keep my functions in one or more text-files ready to be
dropped/recreated when I make schema changes during development.

I believe that the TCL/Perl procedural languages are interpreted each time
they are run so should not suffer this difficulty.

--
  Richard Huxton

pgsql-general by date:

Previous
From: Joel Rees
Date:
Subject: Re: SOLUTION: Insert a Euro symbol as UTF-8 from a latin1 charset.
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: full featured alter table?