From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | RStefko(at)aol(dot)com |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAdmin III bug with transaction failure |
Date: | 2004-09-17 09:53:56 |
Message-ID: | 414AB434.6030306@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-09-17 11:54:35 | Re: Bug: pgAdmin III v1.2.0 Beta 1 - wrong color |
Previous Message | Andreas Pflug | 2004-09-17 09:51:23 | Re: Bug: pgAdmin III v1.2.0 Beta 1 - wrong color |