- Mailing list pgadmin-support
From | Eduardo Valentin |
---|---|
Subject | |
Date | |
Msg-id | GUCUXF$I6C35THtkMuH1gPcCePPQ0Idfcm9X7plnUCX@bol.com.br Whole thread Raw |
List | pgadmin-support |
Hi I'm using PostgreSQL 7.2 PgAdminII 1.2.0 psqlODBC 7.1.9 PgAdmin can connect the database, but when I click the databases section in database tree the pgAdmin get a loop. It stays trying to list the databases for a big time (More than 30 min). So I Kill it. I had uninstalled PgAdmin and installed it again. But I got the same problem. What is my wrong Here it's my log file (Full log) /******************************************************** ****************/ 2002-04-10 09:49:45 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Log Level", 1, "4") 2002-04-10 09:49:45 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II\Log Window", "Always On Top", 1, "N") 2002-04-10 09:49:45 - Entering pgSchema:pgServer.Property Let ShowPassword(True) 2002-04-10 09:49:45 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Mask Password", 1, "N") 2002-04-10 09:49:45 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "AutoHighlight", 1, "ALTER|0|0|16711680;COMMENT|0|0|16711680;CREATE|0|0|16 711680;DELETE|0|0|16711680;DROP|0|0|16711680;EXPLAIN|0|0| 16711680;GRANT|0|0|16711680;INSERT|0|0|16711680;REVOKE|0| 0|16711680;SELECT|0|0|16711680;UPDATE|0|0|16711680;VACUUM |0|0|16711680;AGGREGATE|0|0|255;CONSTRAINT|0|0|255;DATABA SE|0|0|255;FUNCTION|0|0|255;GROUP|0|0|255;INDEX|0|0|255;L ANGUAGE|0|0|255;OPERATOR|0|0|255;RULE|0|0|255;SEQUENCE|0| 0|255;TABLE|0|0|255;TRIGGER|0|0|255;ABORT|0|0|11998061;BE GIN|0|0|11998061;CHECKPOINT|0|0|11998061;CLOSE|0|0|119980 61;CLUSTER|0|0|11998061;COMMIT|0|0|11998061;COPY|0|0|1199 8061;DECLARE|0|0|11998061;FETCH|0|0|11998061;LISTEN|0|0|1 1998061;LOAD|0|0|11998061;LOCK|0|0|11998061;MOVE|0|0|1199 8061;NOTIFY|0|0|11998061;REINDEX|0|0|11998061;RESET|0|0|1 1998061;ROLLBACK|0|0|11998061;SET|0|0|11998061;SHOW|0|0|1 1998061;TRUNCATE|0|0|11998061;UNLISTEN|0|0|11998061;AND|0 |0|32768;AS|0|0|32768;ASC|0|0|32768;ASCENDING|0|0|32768;B Y|0|0|32768;CASE|0|0|32768;DESC|0|0|32768;DESCENDING|0|0| 32768;ELSE|0|0|32768;FROM|0|0|32768;END|0|0|32768;HAVING| 0|0|32768;INTO|0|0|32768;ON|0|0|32768;OR|0|0|32768;ORDER| 0|0|32768;THEN|0|0|32768;USING|0|0|32768;WHEN|0|0|32768;W HERE|0|0|32768;") 2002-04-10 09:49:45 - Entering pgSchema:pgServer.Property Get ConnectionString() 2002-04-10 09:49:45 - Entering pgAdmin II:basRegistry.RegRead(-2147483647, "Software\pgAdmin II", "Master DB") 2002-04-10 09:49:45 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Master DB", 1, "template1") 2002-04-10 09:49:45 - Entering pgSchema:pgServer.Property Let EncryptPasswords(True) 2002-04-10 09:49:45 - Entering pgAdmin II:basRegistry.RegWrite(-2147483647, "Software\pgAdmin II", "Encrypt Passwords", 1, "Y") 2002-04-10 09:49:46 - Entering pgAdmin II:frmMain.imgSplitter_MouseMove(0, 0, 30, 1800) 2002-04-10 09:49:46 - Entering pgAdmin II:frmMain.tv_NodeClick("127.0.0.1\Databases") 2002-04-10 09:49:46 - Examining database... 2002-04-10 09:49:46 - Entering pgAdmin II:frmMain.txtDefinition_Change() 2002-04-10 09:49:46 - Entering pgAdmin II:frmMain.txtDefinition_Change() 2002-04-10 09:49:46 - Entering pgAdmin II:frmMain.tvDatabases("127.0.0.1\Databases") 2002-04-10 09:49:46 - Entering pgSchema:pgServer.Property Get Databases() 2002-04-10 09:49:46 - Entering pgSchema:Databases.Initialize() 2002-04-10 09:49:46 - Entering pgSchema:pgServer.Property Get Connection() 2002-04-10 09:49:46 - Entering pgSchema:pgServer.Property Get Connection() 2002-04-10 09:49:46 - Entering pgSchema:pgServer.ExecSQL ("SELECT oid, *, pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname", "Connection: Provider=MSDASQL.1;Extended Properties="DRIVER= {PostgreSQL};DATABASE=template1;SERVER=127.0.0.1;PORT=543 2;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDI NDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0 ;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVA RCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=0; OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1; UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFRE ESTMT=0;EXTRASYSTABLEPREFIXES=dd_"") 2002-04-10 09:49:46 - SQL (template1): SELECT oid, *, pg_encoding_to_char(encoding) AS encodingname, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname 2002-04-10 09:49:52 - Entering pgSchema:Databases.iAdd (16555, "template0", "", "Administrador", 0, SQL_ASCII) 2002-04-10 09:49:52 - Entering pgSchema:pgServer.Property Get LastSystemOID() 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let SystemObject(False) 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let OID(16555) 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Name("template0") 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Path("") 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Owner("Administrador") 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Encoding(0) 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let EncodingName(SQL_ASCII) 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Identifier("template0") 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Get Identifier() 2002-04-10 09:49:52 - Entering pgSchema:Databases.iAdd (1, "template1", "", "Administrador", 0, SQL_ASCII) 2002-04-10 09:49:52 - Entering pgSchema:pgServer.Property Get LastSystemOID() 2002-04-10 09:49:52 - Entering pgSchema:pgServer.Property Get IncludeSys() 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let SystemObject(True) 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let OID(1) 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Name("template1") 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Path("") 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Owner("Administrador") 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Encoding(0) 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let EncodingName(SQL_ASCII) 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Let Identifier("template1") 2002-04-10 09:49:52 - Entering pgSchema:pgDatabase.Property Get Identifier() 2002-04-10 09:49:53 - Entering pgSchema:Databases.iAdd (16557, "testedelphi", "", "Administrador", 0, SQL_ASCII) 2002-04-10 09:49:53 - Entering pgSchema:pgServer.Property Get LastSystemOID() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Let SystemObject(False) 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Let OID(16557) 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Let Name("testedelphi") 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Let Path("") 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Let Owner("Administrador") 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Let Encoding(0) 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Let EncodingName(SQL_ASCII) 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Let Identifier ("testedelphi") 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get Identifier() 2002-04-10 09:49:53 - Entering pgSchema:Databases.Property Get Count(True) 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:53 - Entering pgSchema:pgServer.Property Get Databases() 2002-04-10 09:49:53 - Entering pgSchema:Databases.Property Get NewEnum() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get Status() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.dbConnect() 2002-04-10 09:49:53 - Entering pgSchema:pgServer.Property Get Connection() 2002-04-10 09:49:53 - Entering pgSchema:pgServer.Property Get MasterDB() 2002-04-10 09:49:53 - Entering pgSchema:pgServer.Property Get ShowPassword() 2002-04-10 09:49:53 - Opening cnDatabase: Provider=MSDASQL.1;Extended Properties="DRIVER= {PostgreSQL};DATABASE=template0;SERVER=127.0.0.1;PORT=543 2;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDI NDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0 ;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVA RCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=0; OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1; UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFRE ESTMT=0;EXTRASYSTABLEPREFIXES=dd_" 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get Identifier() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.Property Get Status() 2002-04-10 09:49:53 - Entering pgSchema:pgDatabase.dbConnect() 2002-04-10 09:49:53 - Entering pgSchema:pgServer.Property Get Connection() 2002-04-10 09:49:53 - Entering pgSchema:pgServer.Property Get MasterDB() 2002-04-10 09:49:53 - Entering pgSchema:pgServer.Property Get ShowPassword() 2002-04-10 09:49:53 - Opening cnDatabase: Provider=MSDASQL.1;Extended Properties="DRIVER= {PostgreSQL};DATABASE=testedelphi;SERVER=127.0.0.1;PORT=5 432;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOI DINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES =0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAX VARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG= 0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR= 1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASF REESTMT=0;EXTRASYSTABLEPREFIXES=dd_" 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.Property Get Identifier() 2002-04-10 09:49:56 - Entering pgSchema:pgServer.Property Get Databases() 2002-04-10 09:49:56 - Entering pgSchema:Databases.Property Get NewEnum() 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.Property Get Identifier() 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.Property Get Comment() 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.LookupComment(16555) 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.dbConnect() 2002-04-10 09:49:56 - Entering pgSchema:pgServer.Property Get Connection() 2002-04-10 09:49:56 - Entering pgSchema:pgServer.Property Get MasterDB() 2002-04-10 09:49:56 - Entering pgSchema:pgServer.Property Get ShowPassword() 2002-04-10 09:49:56 - Opening cnDatabase: Provider=MSDASQL.1;Extended Properties="DRIVER= {PostgreSQL};DATABASE=template0;SERVER=127.0.0.1;PORT=543 2;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDI NDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0 ;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVA RCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG=0; OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR=1; UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFRE ESTMT=0;EXTRASYSTABLEPREFIXES=dd_" 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.Property Get SystemObject() 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.Property Get Identifier() 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.Property Get Comment() 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.LookupComment(16557) 2002-04-10 09:49:56 - Entering pgSchema:pgDatabase.dbConnect() 2002-04-10 09:49:56 - Entering pgSchema:pgServer.ExecSQL ("SELECT * FROM pg_description", "Connection: Provider=MSDASQL.1;Extended Properties="DRIVER= {PostgreSQL};DATABASE=testedelphi;SERVER=127.0.0.1;PORT=5 432;UID=Administrador;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOI DINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES =0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAX VARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;DEBUG=0;COMMLOG= 0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXTASLONGVARCHAR= 1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASF REESTMT=0;EXTRASYSTABLEPREFIXES=dd_"") 2002-04-10 09:49:56 - SQL (testedelphi): SELECT * FROM pg_description 2002-04-10 09:49:58 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:49:59 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:49:59 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:49:59 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:00 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:00 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:00 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:01 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:01 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:01 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:01 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:02 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:02 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:02 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:03 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:03 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:03 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:03 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:04 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:04 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:04 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:05 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:05 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:05 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:05 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:06 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:06 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:06 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:06 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:07 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:07 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:07 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:08 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:08 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:09 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:09 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:09 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:09 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:10 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:10 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:10 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:11 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:11 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:11 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:11 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:12 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:12 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:12 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:13 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:13 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:13 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:14 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:14 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:14 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:15 - Entering pgSchema:pgServer.Property Get dbVersion() 2002-04-10 09:50:15 - Entering /******************************************************** ****************/ Best regards, Eduardo Bezerra __________________________________________________________________________ Quer ter seu próprio endereço na Internet? Garanta já o seu e ainda ganhe cinco e-mails personalizados. DomíniosBOL - http://dominios.bol.com.br
pgadmin-support by date: