Re: lock entire database

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:

begin;
<change your schema>;
commit;



Regards
Gaetano Mendola