Re: Error in creating the backend query - Mailing list pgsql-admin

From Tom Lane
Subject Re: Error in creating the backend query
Date
Msg-id 21743.1248907398@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error in creating the backend query  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Responses Re: Error in creating the backend query  ("Benjamin Krajmalnik" <kraj@illumen.com>)
List pgsql-admin
"Benjamin Krajmalnik" <kraj@illumen.com> writes:
> Below is the full stored procedure.

All I can do is repeat that plpgsql does not behave that way.  It never
has AFAIR, and it most definitely doesn't in any version new enough to
recognize the COST option to CREATE FUNCTION (ie, 8.3 and up).  In fact,
I don't believe that commands executed in a plpgsql function will get
logged at all in 8.3 or later --- they are not according to my tests.

Perhaps you are running some largely hand-hacked local version of plpgsql?
Perhaps you're just confused about what's generating the log entry?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Re: Error in creating the backend query
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Re: Error in creating the backend query