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.
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 |