Re: [PATCHES] Continue transactions after errors in psql

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: [PATCHES] Continue transactions after errors in psql
Дата
Msg-id 426E53BD.1040806@commandprompt.com
обсуждение исходный текст
Ответ на Re: [PATCHES] Continue transactions after errors in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PATCHES] Continue transactions after errors in psql
Список pgsql-hackers
> I would far rather see people code explicit markers around statements
> whose failure can be ignored.  That is, a script that needs this
> behavior ought to look like
>
>     BEGIN;
>     \begin_ignore_error
>     DROP TABLE foo;
>     \end_ignore_error
>     CREATE ...
>     ...
>     COMMIT;

That seems awful noisy. Why not just:

       BEGIN:
       DROP TABLE foo;
       ERROR: table foo does not exist;
       CONTINUE;
       etc....

Sincerely,

Joshua D. Drake
Command Prompt, Inc.




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCHES] Continue transactions after errors in psql
Следующее
От: Harald Fuchs
Дата:
Сообщение: Re: Continue transactions after errors in psql