execute arbitrary SQL queries

From: "fnievinski2" <fnievinski2(at)terra(dot)com(dot)br>
To: pgadmin-support(at)postgresql(dot)org
Subject: execute arbitrary SQL queries
Date: 2002-03-21 20:43:07
Message-ID: GTCC7V$IjdN0jDV8IFkS6U7sUXI0VE7APmkMdr60R1NU@terra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-03-22 20:35:53 Mailling List Archives
Previous Message Serkan Bektaş 2002-03-21 20:07:38 PgAdminII 1.2.0