Re: Lock full database

From: Haller Christoph <ch(at)rodos(dot)fzk(dot)de>
To: guard(at)ficnet(dot)net
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Lock full database
Date: 2001-10-25 17:07:32
Message-ID: 200110251507.RAA02176@rodos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


>
> I want lock full tables,how to write SQL command?
> thanks
>
BEGIN ;
LOCK TABLE <tablename> ;
/* done, locked until "commit;" */

Refer to the SQL-LOCK-command for further
information.
Regards, Christoph

Browse pgsql-sql by date

  From Date Subject
Next Message Alexey Prohorenko 2001-10-25 18:25:33 [LONGINT] Problem
Previous Message Haller Christoph 2001-10-25 16:47:02 Re: How to find primary keys by querying system tables