Skip site navigation (1) Skip section navigation (2)

Re: execute arbitrary SQL queries

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: 'fnievinski2' <fnievinski2(at)terra(dot)com(dot)br>,pgadmin-support(at)postgresql(dot)org
Subject: Re: execute arbitrary SQL queries
Date: 2002-03-22 20:43:39
Message-ID: FED2B709E3270E4B903EB0175A49BCB10476E0@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
Thanks, I'll take a look.

Regards, Dave.

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

pgadmin-support by date

Next:From: Dave PageDate: 2002-03-22 20:45:52
Subject: Re: PgAdminII 1.2.0
Previous:From: Dave PageDate: 2002-03-22 20:35:53
Subject: Mailling List Archives

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group