Hello 2011/12/15 Albe Laurenz <laurenz.a...@wien.gv.at>: > Pavel Stehule wrote: >> so removed "quite" option >> and removed multiple check regression tests also - there is missing >> explicit order of function checking, so regress tests can fail :( > > There seems to be a problem with the SET clause of CREATE FUNCTION: > > ftest=# CREATE OR REPLACE FUNCTION a(integer) RETURNS integer > LANGUAGE plpgsql AS 'BEGIN RETURN 2*$1; END'; > CREATE FUNCTION > ftest=# CHECK FUNCTION a(integer); > NOTICE: checked function "a(integer)" > CHECK FUNCTION > ftest=# CREATE OR REPLACE FUNCTION a(integer) RETURNS integer > LANGUAGE plpgsql SET search_path=public AS 'BEGIN RETURN 2*$1; END'; > CREATE FUNCTION > ftest=# CHECK FUNCTION a(integer); > The connection to the server was lost. Attempting reset: Failed. > !> >
There was bug - missing detoast call fixed Regards Pavel > Yours, > Laurenz Albe
check_function-2011-12-15-1.diff.gz
Description: GNU Zip compressed data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers