execute arbitrary SQL queries
От | fnievinski2 |
---|---|
Тема | execute arbitrary SQL queries |
Дата | |
Msg-id | GTCC7V$IjdN0jDV8IFkS6U7sUXI0VE7APmkMdr60R1NU@terra.com.br обсуждение исходный текст |
Список | 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 по дате отправления: