Yes, I think so. What search path do you mean? These tables were all temporary tables.

Dirk


Tom Lane wrote:
=?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= <[EMAIL PROTECTED]> writes:

The problem I'm facing is the following:


cs1=# select relname from pg_class where relname like 'bm%';
              relname
-----------------------------------
 bm_pagehits_1133271374_047421_941
 bm_pagehits_1133271378_920896_129
 bm_pagehits_1133282272_744243_536
 bm_pagehits_1133284780_743839_884
(4 rows)


cs1=# drop table bm_pagehits_1133271374_047421_941;
ERROR:  table "bm_pagehits_1133271374_047421_941" does not exist


Uh, are you sure these are in a schema that's in your search path?

                        regards, tom lane


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to