Postgres Pro
Downloads
Home   >   mailing lists

Re: Lock full database - Mailing list pgsql-sql

From Haller Christoph
Subject Re: Lock full database
Date
Msg-id 200110251507.RAA02176@rodos
Whole thread Raw
In response to Lock full database  ("guard" <guard@ficnet.net>)
List pgsql-sql
Tree view 
> 
> 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

pgsql-sql by date:

Previous
From: Reiner Dassing
Date:
Subject: Re: [HACKERS] Index of a table is not used (in any case)
Next
From: "Josh Berkus"
Date:
Subject: Re: GUID in postgres