AW: bug with dropping tables and transactions.

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Alfred Perlstein'" <bright(at)wintelcom(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: AW: bug with dropping tables and transactions.
Date: 2000-09-12 07:37:02
Message-ID: 11C1E6749A55D411A9670001FA687963368070@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2000-09-12 07:42:41 AW: new relkind for view
Previous Message Tom Lane 2000-09-12 06:58:22 Dibs for upcoming commit