Thread: SQL-Scripts aren't executed correctly from within pgAdminIII-Quer y tool
Hello,
I found that pgAdminIII-Query tool does not execute SQL scripts correctly.
pgAdminIII 1.2.0
PostgrSQL 7.3.2
Windows 2000
The SQL script has been loaded by "file open" into the command editing pane.
The script is executed as the table owner.
The script contains several delete, select and insert commands.
It performs ok, when invoked from psql as same db user.
It doesn't use any parameters.
The script contains comments in the form -- <comment>
There are no error messages in pgAdmin during execution.
It seems, that after a certain point of the script the rest of the script simply is ignored, since the insert statements after a certain point of the script dont have any evect, i. e. they don't insert any data at all.
With previous version of pgAdmin (1.0.0.?) the point after which the commands have been ignored was 3 sql statements earlier (same script).
Any idea what the problem might bee?
Regards
Wolfram Loy
SEKAS GmbH, Baierbrunner Straße 23
D-81379 München, Deutschland
Tel: +49 (89) 74 81 34 - 29 (Durchwahl) oder +49 (89) 74 81 34 - 0 (Zentrale)
FAX: +49 (89) 74 81 34 99
Email: loy@sekas.de
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/
Loy Wolfram wrote: > Hello, > > I found that pgAdminIII-Query tool does not execute SQL scripts correctly. This problem is unknown. You probably marked a part of the text, which makes pgadmin execute that queries only. Regards, Andreas