Re: stopping access to a database

Ooooooooohhhhhhhhhhh,
That would work! I didn't know I could get an exclusive lock on tables in a transaction,
I thought it was just for rows, (the opposite of MySQL). This is good, and 'back to the
manual' for more reading!

1/28/2003 12:22:50 PM, Neil Conway <neilc(at)samurai(dot)com> wrote:

>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(at)samurai(dot)com> || PGP Key ID: DB3C29FC
>
>
>
>