Re: stopping access to a database
От | Dennis Gearon |
---|---|
Тема | Re: stopping access to a database |
Дата | |
Msg-id | KFQOMK1YWVMECFKGKJ3WYX1UMGQK84.3e371c28@cal-lab обсуждение исходный текст |
Ответ на | Re: stopping access to a database (Neil Conway <neilc@samurai.com>) |
Ответы |
Re: stopping access to a database
|
Список | pgsql-general |
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@samurai.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@samurai.com> || PGP Key ID: DB3C29FC > > > >
В списке pgsql-general по дате отправления: