BUG #11966: Cannot drop tables

On Fri, Nov 14, 2014 at 4:49 PM, <anandhi.arumugam@nexenta.com> wrote:

The following bug has been logged on the website:

Bug reference: 11966
Logged by: Anandhi
Email address: anandhi.arumugam@nexenta.com
PostgreSQL version: Unsupported/Unknown
Operating system: Red Hat Linux 6
Description:

I need to drop a few tables in my Postgres DB. I tried the following

Cannot read termcap database;
using dumb terminal settings.
jiradb=> drop table "AO_3A3ECC_JIRACOMMENT_MAPPING";
DROP TABLE
jiradb=> drop table "AO_3A3ECC_REMOTE_IDCF";
DROP TABLE
jiradb=> drop table "AO_3A3ECC_JIRAPROJECT_MAPPING";
ERROR: cache lookup failed for constraint 1152954
jiradb=>

Why do i get this error? how do i fix this?

Which version of PostgreSQL are you using? Could you provide an
isolated test case able to reproduce this issue? Without an idea of
the schema used for those tables it is not really possible to guess
what may have dropped the constraint AO_3A3ECC_JIRAPROJECT_MAPPING
depends on.
--
Michael

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs