Re: stopping access to a database
От
Neil Conway
Тема
Re: stopping access to a database
Дата
Msg-id
1043785370.9546.69.camel@tokyo
Ответ на
stopping access to a database (Dennis Gearon)
Список
Дерево обсуждения
stopping access to a database Dennis Gearon <gearond@cvc.net>
Re: stopping access to a database Charles Tassell <ctassell@isn.net>
Re: stopping access to a database Dennis Gearon <gearond@cvc.net>
Re: stopping access to a database "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: stopping access to a database Neil Conway <neilc@samurai.com>
Re: stopping access to a database Dennis Gearon <gearond@cvc.net>
Re: stopping access to a database "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
How do I unsubscribe? Gordan Bobic <gordan@bobich.net>
Re: How do I unsubscribe? "Terri Lerose" <Terri.Lerose@att.net>
Re: How do I unsubscribe? "scott.marlowe" <scott.marlowe@ihs.com>
Re: How do I unsubscribe? Will Lowe <harpo@thebackrow.net>
Re: How do I unsubscribe? "Matt Block" <blockdev@blockdev.net>
Re: How do I unsubscribe? Michelle Murrain <tech@murrain.net>
Re: How do I unsubscribe? Dennis Gearon <gearond@cvc.net>
Re: How do I unsubscribe? Martin Kutschker <Martin.Kutschker@blackbox.net>
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 || PGP Key ID: DB3C29FC
В списке pgsql-general по дате отправления
