Re: stopping access to a database

On Tue, 2003-01-28 at 11:50, Dennis Gearon wrote:
> I would like to stop accesses to database 2, delete all records in the 2-4 tables, and reimport
> new records. How would I do this as a user on the system, not as an admin?

How about starting a transaction, acquiring an exclusive lock on all the
tables using LOCK TABLE, deleting & updating the data, and then
committing the transaction?

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC