Thread: BUG #11966: Cannot drop tables

BUG #11966: Cannot drop tables

From
anandhi.arumugam@nexenta.com
Date:
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?

Re: BUG #11966: Cannot drop tables

From
Michael Paquier
Date:
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