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.
With PostgreSQL running in autocommit mode the separate transactions are
implied, but I have also tried isolating the SQL DROP and CREATE statements in
separate transactions.