Обсуждение:

Поиск
Список
Период
Сортировка

От
"Eduardo Valentin"
Дата:
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



Re:

От
Dave Page
Дата:
Hi,

In the ODBC Datasource Administrator in the control panel, on the Tracing
tab please make sure tracing is turned off and try again.

Regards, Dave.

> -----Original Message-----
> From: Eduardo Valentin [mailto:edubezval@bol.com.br]
> Sent: 10 April 2002 15:01
> To: pgadmin-support@postgresql.org
> Subject: [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
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>