Thread: infinite loop

infinite loop

From
Robert
Date:
When I connect from pgadmin2 on my xp box to
postgresql on my linux box, pgadmin2 stops responding
after the last line in the log below, while the linux
drive continues to churn. I am a newbie - any
assistance would be much appreciated.

----------------------


Properties="DRIVER={PostgreSQL};DATABASE=template0;SERVER=192.168.254.22;PORT=5432;UID=postgres;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_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"
2002-06-05 01:22:22 - Entering
pgSchema:pgDatabase.Property Get SystemObject()
2002-06-05 01:22:22 - Entering
pgSchema:pgDatabase.Property Get Identifier()
2002-06-05 01:22:22 - Entering
pgSchema:pgDatabase.Property Get Comment()
2002-06-05 01:22:22 - Entering
pgSchema:pgDatabase.LookupComment(1)
2002-06-05 01:22:22 - Entering
pgSchema:pgDatabase.dbConnect()
2002-06-05 01:22:22 - Populating Comment cache
(database: template1)...
2002-06-05 01:22:22 - Entering
pgSchema:pgServer.Property Get dbVersion()
2002-06-05 01:22:22 - Entering
pgSchema:pgServer.ExecSQL("SELECT objoid, objsubid,
description FROM pg_description", "Connection:
Provider=MSDASQL.1;Extended

Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=192.168.254.22;PORT=5432;UID=postgres;PWD=xxxxxx;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_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"")
2002-06-05 01:22:22 - SQL (template1): SELECT objoid,
objsubid, description FROM pg_description


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

Re: infinite loop

From
"Dave Page"
Date:

> -----Original Message-----
> From: Robert [mailto:roell29@yahoo.com]
> Sent: 05 June 2002 06:37
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] infinite loop
>
>
> When I connect from pgadmin2 on my xp box to
> postgresql on my linux box, pgadmin2 stops responding
> after the last line in the log below, while the linux
> drive continues to churn. I am a newbie - any
> assistance would be much appreciated.
>
>

It's almost certainly not getting stuck in a loop in there, it's
probably just running slowly. Check in the ODBC driver manager (under
Administrative Tools in the Control Panel) and make sure that SQL
Tracing is turned off - this is a *major* performance killer.

Regards, Dave.