Re: can't drop table - Mailing list pgsql-general

From Tom Lane
Subject Re: can't drop table
Date
Msg-id 20964.1126391626@sss.pgh.pa.us
Whole thread Raw
In response to can't drop table  (Brian Hirt <bhirt@mobygames.com>)
List pgsql-general
Brian Hirt <bhirt@mobygames.com> writes:
> I'm a bit baffled by this, i can't drop a table and I'm getting the
> most bizarre message that doesn't make sense to me.  To make things
> worse, I was able to drop it on my test database which is a dump of
> my production database running the same version of postgresql.
> The index it's complaining about is the primary for a different table.

> Does anyone have any ideas?

Can you get a stack trace from the errfinish call to find out what it's
doing exactly?  I suppose something is trying to open that index with
heap_open, but I dunno what.

            regards, tom lane

pgsql-general by date:

Previous
From: liofr
Date:
Subject: gis driver dll .so
Next
From: Tony Caduto
Date:
Subject: Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect