Re: 8.1 and syntax checking at create time

Поиск
Список
Период
Сортировка
От Matt Miller
Тема Re: 8.1 and syntax checking at create time
Дата
Msg-id 1125512887.3640.12.camel@dbamm01-linux
обсуждение исходный текст
Ответ на Re: 8.1 and syntax checking at create time  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Список 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 по дате отправления:

Предыдущее
От: Tony Caduto
Дата:
Сообщение: Re: 8.1 and syntax checking at create time
Следующее
От: Tom Lane
Дата:
Сообщение: Re: On hardcoded type aliases and typmod for user types