Thanks, I'll take a look. Regards, Dave.
> -----Original Message----- > From: fnievinski2 [mailto:[EMAIL PROTECTED]] > Sent: 21 March 2002 20:43 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] execute arbitrary SQL queries > > > 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;FAKEOID > INDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CON > NSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE > =254;MAXLONGVARCHARSIZE=65536;DEBUG=1;COMMLOG=1;OPTIMIZER=1;KS > QO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCH > AR=1;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPRE > FIXES=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. > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > http://www.postgresql.org/users-lounge/docs/faq.html ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
