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.
table foo begin transaction
drop table foo foo becomes foo~1 for all transactions started before the drop
end transaction
foo~1 and mapping are
dropped.
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."