Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] lock table syntax

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Andreas(dot)Zeugswetter(at)telecom(dot)at (Zeugswetter Andreas DBT)
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] lock table syntax
Date: 1998-03-16 04:40:06
Message-ID: 199803160440.XAA21933@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> 
> Hullo,
> 
> I seen the new lock table help in psql:
> I think we should stick to the (pseudo)standard syntax right from the
> beginning.
> Or maybe allow both, but i think at least the table keyword should be
> mandatory 
> to simplify implementation of other locks (like database).
> 
> lock table <tablename> in {exclusive|share} mode;
> 
> What we have now would conform to exclusive mode (works inside a
> transaction only, ok but
> that's the most important case :-).

Added to TODO list.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-03-16 04:40:48
Subject: Re: [HACKERS] VACUUM ANALYZE Problem
Previous:From: Bruce MomjianDate: 1998-03-16 03:45:37
Subject: Re: [QUESTIONS] MySQL benchmark page

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group