Thread: Can't see any tables??

Can't see any tables??

From
Cheryl Thompson
Date:
> I have successfully set up a database with about 6 tables....
> psql can see them and query on them, etc.
> My next step was to move to a gui- namely pgadmin II, of course-- but I'm
> having problems and the help files don't address this.
>
> I can "see" my database on localhost and see it's properties-- but pgadmin
> ii thinks there aren't any tables.
>
> erp!
> Help!
> Cheryl
>
> I'm on W2k and all my builds are whatever was newest and stable as of
> yesterday.
>

Re: Can't see any tables??

From
"Dave Page"
Date:

> -----Original Message-----
> From: Cheryl Thompson [mailto:cthompso@ci.irving.tx.us]
> Sent: 31 December 2002 22:05
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Can't see any tables??
>
>
>
> > I have successfully set up a database with about 6
> tables.... psql can
> > see them and query on them, etc. My next step was to move to a gui-
> > namely pgadmin II, of course-- but I'm having problems and the help
> > files don't address this.
> >
> > I can "see" my database on localhost and see it's properties-- but
> > pgadmin ii thinks there aren't any tables.
> >
> > erp!
> > Help!
> > Cheryl
> >
> > I'm on W2k and all my builds are whatever was newest and
> stable as of
> > yesterday.

There is nothing in the public schema? What about pg_catalog?

Regards, Dave.

frmConnect.cmd Connect_Click: 429 - Class not registered

From
"Marvin Horst"
Date:
When attempting to connect to the database I receive this error message:

==================================================
|    An error has occurred in pgAdmin II:frmConnect.cmdConnect_Click:   |
|
|
|    Number: 429
|
|    Description: Class not registered
|
==================================================

The database is PostgreSQL version 7.1.3  running on RH 7.2.

The is the relevant output from the windows debug.log

=================================================================
2003-01-03 09:13:26 - Entering pgAdmin II:frmConnect.Load_Defaults(0)
2003-01-03 09:13:26 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 1")
2003-01-03 09:13:39 - Entering pgAdmin II:frmConnect.cmd Connect_Click()
2003-01-03 09:13:39 - Connecting to pbz50.pbzinc.loc...
2003-01-03 09:13:39 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
2003-01-03 09:13:39 - Entering pgSchema:pgServer.Property Let
MasterDB("template1")
2003-01-03 09:13:40 - Entering pgSchema:pgServer.Connect("pbz50.pbzinc.loc",
5432, "postgres", "********")
2003-01-03 09:13:40 - Opening cnPostgreSQL:
SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=********;DATABASE=templat
e1;DRIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=
0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNK
NOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;U
SEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;P
ARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
2003-01-03 09:13:41 - Entering pgSchema:pgServer.ExecSQL("SELECT version()",
"Connection: Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL};DAT
ABASE=template1;SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=;ReadOnly
=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTab
les=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;
MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetc
h=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;Cancel
AsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;Dis
allowPremature=0;TrueIsMinus1=0;BI=0"", 0, -1, 1)
2003-01-03 09:13:41 - SQL (template1): SELECT version()
2003-01-03 09:13:42 - Done - 2.18 Secs.

2003-01-03 09:13:42 -
*******************************************************************
2003-01-03 09:13:42 - Error(s)
2003-01-03 09:13:42 -
*******************************************************************
2003-01-03 09:13:42 - Error in pgAdmin II:frmConnect.cmd Connect_Click:
429 - Class not registered
2003-01-03 09:13:42 - The following error(s) have been logged:

  -2147221164 - Class not registered

2003-01-03 09:13:42 - Windows Version: Windows ME v4.90 build 3000
2003-01-03 09:13:42 - pgSchema Version: 1.4.12
2003-01-03 09:13:42 - MDAC Version: 2.6
2003-01-03 09:13:42 - DBMS Version: 07.02.0005 PostgreSQL 7.1.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2003-01-03 09:13:42 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=pbz50.pbzinc.loc;P
ORT=5432;UID=postgres;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;Sh
owOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Soc
ket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;
CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsA
sLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixe
s=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;B
I=0"



frmConnect.cmd Connect_Click: 429 - Class not registered

From
"Marvin Horst"
Date:
When attempting to connect to the database I receive this error message:

==================================================
|    An error has occurred in pgAdmin II:frmConnect.cmdConnect_Click:   |
|
|
|    Number: 429
|
|    Description: Class not registered
|
==================================================

The database is PostgreSQL version 7.1.3  running on RH 7.2.

The is the relevant output from the windows debug.log

=================================================================
2003-01-03 09:13:26 - Entering pgAdmin II:frmConnect.Load_Defaults(0)
2003-01-03 09:13:26 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II\Connections", "Connection 1")
2003-01-03 09:13:39 - Entering pgAdmin II:frmConnect.cmd Connect_Click()
2003-01-03 09:13:39 - Connecting to pbz50.pbzinc.loc...
2003-01-03 09:13:39 - Entering pgAdmin II:basRegistry.RegRead(-2147483647,
"Software\pgAdmin II", "Master DB")
2003-01-03 09:13:39 - Entering pgSchema:pgServer.Property Let
MasterDB("template1")
2003-01-03 09:13:40 - Entering pgSchema:pgServer.Connect("pbz50.pbzinc.loc",
5432, "postgres", "********")
2003-01-03 09:13:40 - Opening cnPostgreSQL:
SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=********;DATABASE=templat
e1;DRIVER={PostgreSQL};READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=
0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNK
NOWNSIZES=0;MAXVARCHARSIZE=254;MAXLONGVARCHARSIZE=65536;OPTIMIZER=1;KSQO=1;U
SEDECLAREFETCH=0;TEXTASLONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=1;BOOLSASCHAR=1;P
ARSE=0;CANCELASFREESTMT=0;EXTRASYSTABLEPREFIXES=dd_;COMMLOG=1;DEBUG=1;
2003-01-03 09:13:41 - Entering pgSchema:pgServer.ExecSQL("SELECT version()",
"Connection: Provider=MSDASQL.1;Extended Properties="DRIVER={PostgreSQL};DAT
ABASE=template1;SERVER=pbz50.pbzinc.loc;PORT=5432;UID=postgres;PWD=;ReadOnly
=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTab
les=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;

MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetc
h=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;Cancel
AsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;Dis
allowPremature=0;TrueIsMinus1=0;BI=0"", 0, -1, 1)
2003-01-03 09:13:41 - SQL (template1): SELECT version()
2003-01-03 09:13:42 - Done - 2.18 Secs.

2003-01-03 09:13:42 -
*******************************************************************
2003-01-03 09:13:42 - Error(s)
2003-01-03 09:13:42 -
*******************************************************************
2003-01-03 09:13:42 - Error in pgAdmin II:frmConnect.cmd Connect_Click:
429 - Class not registered
2003-01-03 09:13:42 - The following error(s) have been logged:

  -2147221164 - Class not registered

2003-01-03 09:13:42 - Windows Version: Windows ME v4.90 build 3000
2003-01-03 09:13:42 - pgSchema Version: 1.4.12
2003-01-03 09:13:42 - MDAC Version: 2.6
2003-01-03 09:13:42 - DBMS Version: 07.02.0005 PostgreSQL 7.1.3 on
i686-pc-linux-gnu, compiled by GCC 2.96
2003-01-03 09:13:42 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=pbz50.pbzinc.loc;P
ORT=5432;UID=postgres;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;Sh
owOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Soc
ket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=1;
CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsA
sLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixe
s=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;B
I=0"