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.
