Re: 7.1 LOCK TABLE changes - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: 7.1 LOCK TABLE changes
Date
Msg-id Pine.LNX.4.30.0106052329550.900-100000@peter.localdomain
Whole thread Raw
In response to 7.1 LOCK TABLE changes  (Brian Powell <brian@owlscreech.com>)
List pgsql-sql
Brian Powell writes:

> In our client app, we lock our table before doing something to it.
> Fortunately, in 7.0.3, a view looked like a table and we could perform:
>
> lock v_whatever in share row exclusive mode;

There is no and never was any point in locking a view, since it doesn't
contain any data.  Usually, you don't need explicit locks anyway, but I
can't tell from here why you might want to.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: query on two databases ..
Next
From: clayton cottingham
Date:
Subject: plperl