Re: execute sql script w/o stopping after error?

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: execute sql script w/o stopping after error?
Дата
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40103DDC9@ratbert.vale-housing.co.uk
обсуждение исходный текст
Ответ на execute sql script w/o stopping after error?  ("Carl R. Brune" <brune@ohio.edu>)
Ответы Re: execute sql script w/o stopping after error?  ("Carl R. Brune" <brune@ohio.edu>)
Список pgadmin-hackers

> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org
> [mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
> Carl R. Brune
> Sent: 31 January 2006 18:33
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] execute sql script w/o stopping
> after error?
>
> Does pgadmin3 offer a way to execute sql scripts without
> stopping if an error is encountered? I've got a script
> which starts by dropping table (which may or may not exist)
> and then rebuilds it. If I execute the script with psql
> (using \i) script execution continues after errors. However
> if I try to do this with the query tool of pgadmin3 it stops
> after the drop table statement (if the table doesn't exist).

No, at present it doesn't. You can select only specific portions of your
script to run by selecting the text, and then clicking the run button
though.

Regards, Dave.

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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Patch: Query favourites
Следующее
От: "Hiroshi Saito"
Дата:
Сообщение: Re: [pgadmin-support] "view data" freezes up every time