SQL-Scripts aren't executed correctly from within pgAdminIII-Quer y 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-Quer y tool
Date: 2004-12-06 09:53:24
Message-ID: 5DC03B9B3DD76F49AD075AD4DC1C276F0AB8E9@exchsrv.sekas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

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