Re: Create function statement with insert statement

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема Re: Create function statement with insert statement
Дата
Msg-id 3E71EFB9.CD27D06B@rodos.fzk.de
обсуждение исходный текст
Ответ на Create function statement with insert statement  ("Susan Hoddinott" <susan@hexworx.com>)
Список pgsql-sql
>
> Hi Chris,
>
> Thanks for your efforts but seems like something very odd is going on
> because even though I commented out the constraints I still received
the
> parse errors.
>
> I searched the archives but looked for references to triggers and
functions
> rather than parse errors.
>
> Regards
>
Susan,

Could you check if the SQL procedural language is available at all by

select * from pg_language ;lanname  | lanispl | lanpltrusted | lanplcallfoid | lanvalidator |
lanacl
----------+---------+--------------+---------------+--------------+--------
sql      | f       | t            |             0 |         2248 | {=U}
internal | f       | f            |             0 |         2246 | {=}c        | f       | f            |             0
|        2247 | {=}
 
(3 rows)

These three should show up by default; Maybe somebody dropped it
accidentally.

Regards, Christoph




В списке pgsql-sql по дате отправления:

Предыдущее
От: "Susan Hoddinott"
Дата:
Сообщение: Re: Create function statement with insert statement
Следующее
От: Andreas Schmitz
Дата:
Сообщение: Re: Create function statement with insert statement