Re: can't drop table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Hirt <bhirt(at)mobygames(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: can't drop table
Date: 2005-09-10 22:33:46
Message-ID: 20964.1126391626@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brian Hirt <bhirt(at)mobygames(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2005-09-10 23:01:47 Re: EMS PostgreSQL Manager vs. TheKompany DataArchitect
Previous Message liofr 2005-09-10 22:24:37 gis driver dll .so