Thread: 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;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.

Thanks, I'll take a look.

Regards, Dave.

> -----Original Message-----
> From: fnievinski2 [mailto:fnievinski2@terra.com.br]
> Sent: 21 March 2002 20:43
> To: pgadmin-support@postgresql.org
> 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