From: | "Carl R(dot) Brune" <brune(at)ohio(dot)edu> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Re: execute sql script w/o stopping after error? |
Date: | 2006-02-02 20:59:37 |
Message-ID: | Pine.LNX.4.61.0602021555320.1085@cerastes.phy.ohiou.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Thanks, Dave, for the helpful reply.
I have a feeling I sent my question to the wrong list --
sorry if that's the case. According to
http://www.pgadmin.org/support/list.php
"The pgadmin-support mailing list is intended for end user support
and bug reports. To subscribe to the mailing list, send an email
to pgadmin-hackers-request(at)postgresql(dot)org with the word 'subscribe',
without quotes, as the body of message."
Looks wrong, or at least misleading.
Anway, thanks again and regards,
Carl B.
On Thu, 2 Feb 2006, Dave Page wrote:
>
>
>> -----Original Message-----
>> From: pgadmin-hackers-owner(at)postgresql(dot)org
>> [mailto:pgadmin-hackers-owner(at)postgresql(dot)org] On Behalf Of
>> Carl R. Brune
>> Sent: 31 January 2006 18:33
>> To: pgadmin-hackers(at)postgresql(dot)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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2006-02-02 21:37:44 | SVN Commit by dpage: r4985 - trunk/www/support |
Previous Message | Andrus | 2006-02-02 19:54:28 | Re: "view data" freezes up every time |