Re: ERROR: CreateTrigger: function.....

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ERROR: CreateTrigger: function.....
Дата
Msg-id 8016.1054562542@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ERROR: CreateTrigger: function.....  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Richard Huxton <dev@archonet.com> writes:
>> However when I want to see whether it is really present I type \df
>> myfunctionsname(); within the psql interface, but without a positive
>> result! Any other user-defined function I create which doesn't have an
>> OPAQUE return type, does show up in the list of functions when I issue the
>> \dt-command!

> Difficult to say what's happening here - especially as you say you're happily
> creating other functions.

I think it's getting created but \df isn't showing it.  At one time \df
deliberately excluded functions that returned OPAQUE.  This isn't true
anymore as of 7.3 ...

            regards, tom lane

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

Предыдущее
От: erwan ancel
Дата:
Сообщение: Re: check constraint
Следующее
От: "Bodanapu, Sravan"
Дата:
Сообщение: Re: [ADMIN] Error while loading external data into Postgres table