AW: bug with dropping tables and transactions. - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: bug with dropping tables and transactions.
Date
Msg-id 11C1E6749A55D411A9670001FA687963368070@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: bug with dropping tables and transactions.
List pgsql-hackers
> There seems to a race condition somewhere where that if you're
> running let's say pg_dumpall and happen to drop a table mid-dump
> pg_dumpall will die because it looses the table.
> 
> Would it make sense to use a transaction system so that when a table
> is renamed/dropped it doesn't actually go away until all transactions
> that started before the drop take place?
> 
> one could do probably implement this using refcounts and translating
> dropped tables into temporary mangled names.

Imho if I dropped a table I would not like another session to still access
it,
so we should imho rather fix pg_dump.

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Dibs for upcoming commit
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: new relkind for view