Re: [BUGS] BUG #7802: Cannot drop table because of dependant sequence, but there is link to sequence

2013-01-14 Thread Christiaan Willemsen
Hi Tom,   To bad, I don't have the exact logging... I do however need to de-partition two more tables, probably this week, so I will do some more extensive statement logging and I I get stuck again, I'll post it.   Kind regards,   Christiaan Willemsen  -Original message

Re: [BUGS] BUG #7802: Cannot drop table because of dependant sequence, but there is link to sequence

2013-01-10 Thread Christiaan Willemsen
Hi Tom,   Back again ;) I just checked pg_depend, and according to it there is no relation between in de table and the sequence... There is however a relation between the new table and the old sequence (as expected). So this is sill a mistery.   By the way, I can't to a dump restore, it woul

Re: [BUGS] BUG #7802: Cannot drop table because of dependant sequence, but there is link to sequence

2013-01-10 Thread Christiaan Willemsen
Hi Tom,   Thanks for the answer. I will try to fix the problem via the catalog. As for how I did this.. I hope I can give you a full walkthough:   - We've had a paritioned table with 1 primary key, and two foreign keys (one of them has in index). There were about three partions (all made via a