Re: 8.1 and syntax checking at create time - Mailing list pgsql-hackers

Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
> CREATE or REPLACE FUNCTION public.test_func9(out firstname varchar,out 
> lastname varchar)
> RETURNS SETOF pg_catalog.record AS
> $BODY$
> Declare
> row record44;
> BEGIN
>     asfdfdfdfafdsfsdfsdf
>     sdf bla bla
>     sdf yada yada
>     s
>     df
>     sd
>     fsd
> END;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE;

[ looks at that again... ]  Wait, are you sure that you are talking to
an 8.1 server?  8.1 will certainly catch the garbage syntax in the
function body, whether or not it notices that the type name is bogus.
        regards, tom lane