strange drop errors

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: strange drop errors
Date: 2008-07-02 02:13:39
Message-ID: E5EBA011-B07A-4135-B749-DA532B508D98@kevinkempterllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi List;

in trying to drop an index I get this:

# drop index sl_pf_fact_tmp11_ep_idx11;
ERROR: could not open relation with OID 3666815

I even dropped the associated table and still get this error. Likewise
we cannot create an index with the same name.

Thoughts ?

Browse pgsql-admin by date

  From Date Subject
Next Message sftf 2008-07-02 09:30:44 Roles as objects in Postgres's security system
Previous Message Naomi Walker 2008-07-02 01:41:44 Re: Change a character in a text field