locking a dropped table

From: "Thomas F(dot) O'Connell" <tfo(at)monsterlabs(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: locking a dropped table
Date: 2001-05-15 15:05:03
Message-ID: 3B01459F.7000203@monsterlabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

is there any way to preserve a lock on a table that gets dropped?

i have a situation where it would be nice to have a select wait on a
lock on a table that gets dropped but almost immediately recreated, but,
at the moment, the select generates an error as soon as the table is
dropped if the two actions happen close enough in time.

-tfo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roberto Mello 2001-05-15 15:07:44 Re: [HACKERS] Internet is putting lot of competition fire & heat under Microsoft SQL Server
Previous Message Ryan Mahoney 2001-05-15 14:48:39 Re: Performance aggregates