Re: Raise exception without using plpgsql?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Raise exception without using plpgsql?
Дата
Msg-id CAFj8pRD-Kt1tq2ssqihWirUTsEWg6LJ1ecM1YuJm_rdV_S8bkw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Raise exception without using plpgsql?  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general


čt 17. 12. 2020 v 17:45 odesílatel hubert depesz lubaczewski <depesz@depesz.com> napsal:
On Thu, Dec 17, 2020 at 03:32:09PM +0100, Joel Jacobson wrote:
> Hi,
> Is there a way to raise an exception with a message,
> without having to add your own plpgsql helper-function?
> Currently this is what I have:

Well, you can:
DO $$ begin raise notice 'zz'; END; $$;
It's cheating though, as it still needs plpgsql.

Best regards,

Some years there was discussion about this possibility


There was another thread, but I cannot to find it

Regards

Pavel


depesz



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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Raise exception without using plpgsql?
Следующее
От: Craig McIlwee
Дата:
Сообщение: Unexpected result count from update statement on partitioned table