Search Postgresql Archives

Re: can't drop table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Brian Hirt <bhirt@xxxxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux