Postgres Pro
Downloads
Home   >   mailing lists

Re: stopping access to a database - Mailing list pgsql-general

From Neil Conway
Subject Re: stopping access to a database
Date
Msg-id 1043785370.9546.69.camel@tokyo
Whole thread Raw
In response to stopping access to a database  (Dennis Gearon <gearond@cvc.net>)
Responses Re: stopping access to a database
List pgsql-general
Tree view 
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 by date:

Previous
From: "Zac Hillier"
Date:
Subject: unsubscribe
Next
From: Sean Chittenden
Date:
Subject: Re: Status of tablespaces