Hi,

I am getting the error "Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done." when I try
to view tables in my database with PG Admin. If chose "Continue" then PG
Admin behaves as if I have no tables in this database even though I know
they are there by checking the database in other ways. I have already
tried rebooting, reinstalling and other things but nothing works. I guess
I probably gave a bad command and it could not recover. What should I do?
I hope someone can help me. The last portion of the log file starting from
the command sequence that I gave right before it bugged out on me is below.

Thanks,
Ray


2004-04-02 16:54:19 - SQL (climatology): CREATE TABLE newtable AS SELECT
id, occultation, cmc_data, numalt, cmc_high, datetimestamp, lat_ref,
long_ref, z, t, p, d, lat, long, uts FROM a_priori_tp;

ALTER TABLE newtable RENAME TO a_priori_tp_new;

GRANT SELECT ON TABLE a_priori_tp_new TO PUBLIC;
GRANT ALL ON TABLE a_priori_tp_new TO acelib;

ALTER TABLE a_priori_tp_new ALTER id SET DEFAULT
nextval('"profile_test_id_seq"'::text)

2004-04-02 16:54:30 - SQL (climatology): SELECT oid, relname,
pg_get_userbyid(relowner) as tableowner, relacl, relhasoids FROM pg_class
WHERE ((relkind = 'r') OR (relkind = 's')) ORDER BY relname

2004-04-02 16:54:30 -
************************************************** *****************
2004-04-02 16:54:30 - Error(s)
2004-04-02 16:54:30 -
************************************************** *****************
2004-04-02 16:54:30 - Error in pgAdmin II:frmMain.mnuPopupRefresh_Click:
-2147217887 - Multiple-step OLE DB operation generated errors. Check each
OLE DB status value, if available. No work was done.

2004-04-02 16:54:30 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 4
2004-04-02 16:54:30 - pgSchema Version: 1.6.0
2004-04-02 16:54:30 - MDAC Version: 2.5
2004-04-02 16:54:30 - DBMS Version: 07.03.0100 PostgreSQL 7.2.1 on
sparc-sun-solaris2.8, compiled by cc -Xa
2004-04-02 16:54:30 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1 ;SERVER=databace.uwaterloo.ca;PORT=5432;UID=acelib ;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex =0;ShowOidColumn=0;RowVersioning=0;ShowSystemTable s=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSiz es=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;D ebug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetc h=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;Bo olsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTab lePrefixes=dd_;LFConversion=1;UpdatableCursors=1;D isallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLong VarBinary=0;UseServerSidePrepare=0"

2004-04-02 16:54:38 - SQL (climatology): SELECT objoid, objsubid,
description FROM pg_description
2004-04-02 16:54:38 - SQL (climatology): SELECT relname, n_tup_ins,
n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname
2004-04-02 16:54:57 - SQL (climatology): SELECT relname, n_tup_ins,
n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname
2004-04-02 16:54:57 - SQL (climatology): SELECT relname, n_tup_ins,
n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname

2004-04-02 16:56:31 -
************************************************** *****************
2004-04-02 16:56:31 - Error(s)
2004-04-02 16:56:31 -
************************************************** *****************
2004-04-02 16:56:31 - Error in pgAdmin II:frmSQLOutput.RefreshData: 380 -
Invalid property value

2004-04-02 16:56:31 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 4
2004-04-02 16:56:31 - pgSchema Version: 1.6.0
2004-04-02 16:56:31 - MDAC Version: 2.5
2004-04-02 16:56:31 - DBMS Version: 07.03.0100 PostgreSQL 7.2.1 on
sparc-sun-solaris2.8, compiled by cc -Xa
2004-04-02 16:56:31 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1 ;SERVER=databace.uwaterloo.ca;PORT=5432;UID=acelib ;PWD=********;ReadOnly=0;Protocol=6.4;FakeOidIndex =0;ShowOidColumn=0;RowVersioning=0;ShowSystemTable s=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSiz es=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;D ebug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetc h=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;Bo olsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTab lePrefixes=dd_;LFConversion=1;UpdatableCursors=1;D isallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLong VarBinary=0;UseServerSidePrepare=0"

2004-04-02 17:03:15 - SQL (template1): SELECT numbackends, xact_commit,
xact_rollback, blks_read, blks_hit FROM pg_stat_database WHERE datname =
'climatology'


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend