View Single Post

   
  #2 (permalink)  
Old 04-17-2008, 06:57 PM
Carl R. Brune
 
Posts: n/a
Default Re: execute sql script w/o stopping after error?

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@postgresql.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@postgresql.org
>> [mailtogadmin-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.
>
>


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote