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

From Matt Miller
Subject Re: 8.1 and syntax checking at create time
Date
Msg-id 1125512887.3640.12.camel@dbamm01-linux
Whole thread Raw
In response to Re: 8.1 and syntax checking at create time  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-hackers
On Wed, 2005-08-31 at 13:13 -0500, Tony Caduto wrote:
> the function below also raises no errors at create, but at run time it does.
> ...
> 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;

When I execute this CREATE statement I get:

ERROR:  type "record44" does not exist
CONTEXT:  compile of PL/pgSQL function "test_func9" near line 2

So, it does seem to be working as advertised.

I'm running HEAD as of a few hours ago.


pgsql-hackers by date:

Previous
From: Tony Caduto
Date:
Subject: Re: 8.1 and syntax checking at create time
Next
From: Tom Lane
Date:
Subject: Re: On hardcoded type aliases and typmod for user types