On Nov 21, 2005, at 12:44 PM, Tom Lane wrote:

Bob Ippolito <[EMAIL PROTECTED]> writes:
mochi=# drop table ping_1132387200;
ERROR:  table "ping_1132387200" does not exist
mochi=# create table ping_1132387200();
ERROR:  type "ping_1132387200" already exists

I'm not sure what to do about this..

Try dropping the type.

We've seen at least one prior report of a table's rowtype not being
dropped with the table, but nothing solid enough to debug.  If you can
find a way to reproduce this, I'm all ears.

I did try that, I guess it didn't make it to the list yet:

mochi=# drop type ping_1132387200;
ERROR:  cache lookup failed for relation 211174567

-bob





---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to