"Thomas F. O'Connell" <tfo@monsterlabs.com> writes:
> 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.
When you drop and recreate a table, you do not have the same table
anymore. You have a completely different object that happens to have
the same name as the previous table. So there is no possibility of
having a lock that covers both.
Perhaps rather than dropping the table, you should consider just
removing all its entries.
regards, tom lane
