execute arbitrary SQL queries - Mailing list pgadmin-support

From fnievinski2
Subject execute arbitrary SQL queries
Date
Msg-id GTCC7V$IjdN0jDV8IFkS6U7sUXI0VE7APmkMdr60R1NU@terra.com.br
Whole thread Raw
List pgadmin-support
Hi.

pgAdmin hangs up when I try to execute a single comment line (through
"execute arbitrary SQL queries").
For example:
-- comment line
or
/* another comment line */
both make pgAdmin hang-up. Sometimes it crashes.

If I type the comment line together with another uncommented line, it
works fine.

Also typing "    " + ENTER makes pgAdmin to crash.

I downloaded pgAdmin.exe version 1.43 and downloaded and registered
pgSchema.dll 1.40 and the problem persists.

Here's the log:
2002-03-21 16:23:33 - Executing SQL Query...
2002-03-21 16:23:33 - Entering pgSchema:pgServer.Property Get Databases()
2002-03-21 16:23:33 - Entering pgSchema:Databases.Property Get Item("db1")
2002-03-21 16:23:33 - Entering pgSchema:pgDatabase.Execute("--
comment", 0, -1)
2002-03-21 16:23:33 - Entering pgSchema:pgDatabase.dbConnect()
2002-03-21 16:23:33 - Entering pgSchema:pgServer.ExecSQL("-- comment",
"Connection: Provider=MSDASQL.1;Extended

Properties="DRIVER={PostgreSQL};DATABASE=db1;SERVER=localhost;PORT=5432;UID=trabalhador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=1;COMMLOG=1;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_"")
2002-03-21 16:23:33 - SQL (db1): -- comment


It's a minor issue. I don't believe anyone else will try to execute a
single commented line. :-)

Thanks for the great work.

Felipe N.


pgadmin-support by date:

Previous
From: Serkan Bektaş
Date:
Subject: PgAdminII 1.2.0
Next
From: Dave Page
Date:
Subject: Mailling List Archives