Concurrent modification of plpgsql function body

Alex Vinogradovs <AVinogradovs@Clearpathnet.com> writes:

I've got an application that keeps a persistent connection into the
database and constantly executes number of stored functions. Sometimes
I need to modify the implementation of those functions to change the
data layout, but doing that results in errors like this:

unrecognized node type: 1852387187

This report is far too vague to give a useful reply to.
What exactly do you mean by "modify the implementation"?

regards, tom lane

I mean I re-create the function with the same signature but
different body, and when the application invokes that function
again, it starts getting those errors.

Alex.

Alex Vinogradovs wrote:

I mean I re-create the function with the same signature but
different body, and when the application invokes that function
again, it starts getting those errors.

Are you using CREATE OR REPLACE FUNCTION, or DROP FUNCTION followed by
CREATE FUNCTION?

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Yes, I'm using CREATE OR REPLACE.

Alex.

Alvaro Herrera <alvherre@commandprompt.com> writes:

Alex Vinogradovs wrote:

I mean I re-create the function with the same signature but
different body, and when the application invokes that function
again, it starts getting those errors.

Are you using CREATE OR REPLACE FUNCTION, or DROP FUNCTION followed by
CREATE FUNCTION?

Perhaps more to the point, we need to see a complete example. I don't
see how either way of changing a plpgsql function would result in the
described error.

regards, tom lane