Re: [HACKERS] DROP TABLESPACE needs crash-resistance

2010-11-09 Thread Gurjeet Singh
On Wed, Nov 10, 2010 at 1:24 AM, Tom Lane wrote: > Gurjeet Singh writes: > > We are facing a problem in dropping a tablespace after crash recovery. > The > > recovery starts from the last checkpoint, but the tables that were > created > > by > > a transaction in a tablespace before the checkpoin

Re: [HACKERS] DROP TABLESPACE needs crash-resistance

2010-11-09 Thread Tom Lane
Gurjeet Singh writes: > We are facing a problem in dropping a tablespace after crash recovery. The > recovery starts from the last checkpoint, but the tables that were created > by > a transaction in a tablespace before the checkpoint are still lying around; > the > transaction had not finished by

[HACKERS] DROP TABLESPACE needs crash-resistance

2010-11-09 Thread Gurjeet Singh
We are facing a problem in dropping a tablespace after crash recovery. The recovery starts from the last checkpoint, but the tables that were created by a transaction in a tablespace before the checkpoint are still lying around; the transaction had not finished by the time of crash. After recovery