AW: bug with dropping tables and transactions.

Поиск
Список
Период
Сортировка
Искать
От
Zeugswetter Andreas SB
Тема
AW: bug with dropping tables and transactions.
Дата
Msg-id
11C1E6749A55D411A9670001FA687963368070@sdexcsrv1.f000.d0188.sd.spardat.at
Список
Дерево обсуждения
AW: bug with dropping tables and transactions. Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
Re: bug with dropping tables and transactions. "'Alfred Perlstein'" <bright@wintelcom.net>

> 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 по дате отправления
От: Tom Lane
Дата:
Сообщение: Dibs for upcoming commit
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: new relkind for view
FAQ