Skip site navigation (1) Skip section navigation (2)

SQL-Scripts aren't executed correctly from within pgAdminIII-Query tool

From: Loy Wolfram <Loy(at)sekas(dot)de>
To: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: SQL-Scripts aren't executed correctly from within pgAdminIII-Query tool
Date: 2004-12-06 09:53:24
Message-ID: 5DC03B9B3DD76F49AD075AD4DC1C276F0AB8E9@exchsrv.sekas.de (view raw or flat)
Thread:
Lists: pgadmin-support
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(at)sekas(dot)de

 <http://www.sekas.de/> http://www.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/

Responses

pgadmin-support by date

Next:From: laurie.burrowDate: 2004-12-06 13:25:09
Subject: Reverse engineering problem on views
Previous:From: PicoDate: 2004-12-06 08:35:44
Subject: Re: crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group