Re: pgAdmin III bug with transaction failure

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

RStefko(at)aol(dot)com wrote:
> I'm trying to run a SQL script in pgAdminIII which works in psql but 
> fails in pgAdminIII
>  
> Platform:  XP Professional sp2
> Language: English
> Distribution: pgadmin3-win32.zip  12-Sep-2004 19:34
> Version: 1.2.0 Post Beta 1 (Sep 12 2004)
>  
> Problem:
> The script I'm running drops a table, then creates the table as separate 
> transactions.
>  
> If the table does not exist when executing the DROP Table then I get an 
> error "table 'xxx' does not exist' (which is OK with me) but the second 
> transaction does not execute.

This is normal pgsql behaviour. All statements are executed in a single 
batch/transaction. If one fails, the rest won't be executed.

You can mark the statements individually and execute them manually one 
by one.

Regards,
Andreas