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
Ответ на
Список
Дерево обсуждения
8.1 and syntax checking at create time Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: 8.1 and syntax checking at create time Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: 8.1 and syntax checking at create time Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: 8.1 and syntax checking at create time Tom Lane <tgl@sss.pgh.pa.us>
Re: 8.1 and syntax checking at create time Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: 8.1 and syntax checking at create time Matt Miller <mattm@epx.com>
Re: 8.1 and syntax checking at create time Josh Berkus <josh@agliodbs.com>
Re: 8.1 and syntax checking at create time Matt Miller <mattm@epx.com>
Re: 8.1 and syntax checking at create time Josh Berkus <josh@agliodbs.com>
Re: 8.1 and syntax checking at create time Tom Lane <tgl@sss.pgh.pa.us>
Re: 8.1 and syntax checking at create time Matt Miller <mattm@epx.com>
Re: 8.1 and syntax checking at create time "Jim C. Nasby" <jnasby@pervasive.com>
Re: 8.1 and syntax checking at create time "Jim C. Nasby" <jnasby@pervasive.com>
Re: 8.1 and syntax checking at create time Michael Fuhr <mike@fuhr.org>
Re: 8.1 and syntax checking at create time Tom Lane <tgl@sss.pgh.pa.us>
Re: 8.1 and syntax checking at create time Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: 8.1 and syntax checking at create time Andrew Dunstan <andrew@dunslane.net>
Re: 8.1 and syntax checking at create time Michael Fuhr <mike@fuhr.org>
Re: 8.1 and syntax checking at create time Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: 8.1 and syntax checking at create time Michael Fuhr <mike@fuhr.org>
Re: 8.1 and syntax checking at create time Tom Lane <tgl@sss.pgh.pa.us>
Re: 8.1 and syntax checking at create time Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: 8.1 and syntax checking at create time Tony Caduto <tony_caduto@amsoftwaredesign.com>
Re: 8.1 and syntax checking at create time Tom Lane <tgl@sss.pgh.pa.us>
Re: 8.1 and syntax checking at create time huaxin zhang <uwcssa@gmail.com>
Tracing I/O (was: 8.1 and syntax checking at create time) "Jim C. Nasby" <jnasby@pervasive.com>
Re: Tracing I/O (was: 8.1 and syntax checking at create time) Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: 8.1 and syntax checking at create time Andrew Dunstan <andrew@dunslane.net>
Re: 8.1 and syntax checking at create time Tom Lane <tgl@sss.pgh.pa.us>
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
Дата:
От: Tom Lane
Дата:
FAQ