Re: stopping access to a database

From: Neil Conway <neilc(at)samurai(dot)com>
To: gearond(at)cvc(dot)net
Cc: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: stopping access to a database
Date: 2003-01-28 20:22:50
Message-ID: 1043785370.9546.69.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2003-01-28 20:25:30 Does anyone here speak Castellano?
Previous Message Ryan VanderBijl 2003-01-28 20:01:18 Re: serialization errors