Re: BUG #11966: Cannot drop tables - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #11966: Cannot drop tables
Date
Msg-id CAB7nPqSeCEh9e9KuaVhhDw-0AGH1UiCBtN=Vri4uuFwDBNAUBQ@mail.gmail.com
Whole thread Raw
In response to BUG #11966: Cannot drop tables  (anandhi.arumugam@nexenta.com)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: IPN Bala GSS TVL
Date:
Subject: Re: BUG #11948: Error when installing PostgreSQL 9.3 server
Next
From: Michael Paquier
Date:
Subject: Re: BUG #11973: duplicate supported platforms