Re: [GENERAL] Concurrent modification of plpgsql function body

2008-01-07 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> 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 FUNCTI

Re: [GENERAL] Concurrent modification of plpgsql function body

2008-01-07 Thread Alex Vinogradovs
Yes, I'm using CREATE OR REPLACE. Alex. On Mon, 2008-01-07 at 16:17 -0300, Alvaro Herrera wrote: > 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.

Re: [GENERAL] Concurrent modification of plpgsql function body

2008-01-07 Thread Alvaro Herrera
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 Herr

Re: [GENERAL] Concurrent modification of plpgsql function body

2008-01-07 Thread Alex Vinogradovs
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. On Fri, 2008-01-04 at 15:36 -0500, Tom Lane wrote: > Alex Vinogradovs <[EMAIL PROTECTED]> writes: > > I've got an application t

Re: [GENERAL] Concurrent modification of plpgsql function body

2008-01-04 Thread Tom Lane
Alex Vinogradovs <[EMAIL PROTECTED]> 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

[GENERAL] Concurrent modification of plpgsql function body

2008-01-04 Thread Alex Vinogradovs
Hello all, 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 ty