Steve Tucknott wrote:
> We have a similar request.
> We have a 'program' that does database 'structure' updates and do not
> want the users touching the database while this is going on. In Informix
> this was achieved by placing and EXCLUSIVE lock on the database itself.
> Is there a (simple) way of 'locking out' specific users under PostGre to
> achieve the same end?
Database structures change can be inserted inside a transaction, so you don't
need to lock the entire DB:
<change your schema>;
In response to
pgsql-novice by date
|Next:||From: Gaetano Mendola||Date: 2004-08-06 18:14:10|
|Subject: Re: Tables in one disk and indexes in another ??|
|Previous:||From: Gastón Simone||Date: 2004-08-06 17:51:46|
|Subject: Tables in one disk and indexes in another ??|