The default behavior in pgsql is to allow the use of transactions to isolate SQL statements. PgAdmin seems to batch the entire script into a single transaction, making the user's transaction irrelevant.
Use the mailing list!
To pgAdmin, all you execute is a single statement. Execute them separately or use savepoints.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
