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)
Список
Дерево обсуждения
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>
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 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 || PGP Key ID: DB3C29FC > > > >
В списке pgsql-general по дате отправления
От: Marc G. Fournier
Дата:
