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

From: "Eduardo Valentin" <edubezval(at)bol(dot)com(dot)br>
To: pgadmin-support(at)postgresql(dot)org
Subject:
Date: 2002-04-10 14:00:51
Message-ID: GUCUXF$I6C35THtkMuH1gPcCePPQ0Idfcm9X7plnUCX@bol.com.br (view raw or flat)
Thread:
Lists: 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

Next:From: Dave PageDate: 2002-04-10 14:12:00
Subject: Re:
Previous:From: Dave PageDate: 2002-04-10 08:03:10
Subject: Re: null rows - importing a table with

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