| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: For update |
| Date: | 2006-01-16 17:29:39 |
| Message-ID: | 20060116172938.GA9958@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, Jan 16, 2006 at 02:05:15PM -0300, Alvaro Herrera wrote:
> Ottó Havasvölgyi wrote:
> > What does this do exactly:
> >
> > select * from <ViewName> where <condition> for update;
> >
> > Will be locked all the tuples in all tables it retrieves?
>
> Yes.
>
> > In 8.0.5 this did not work for me.
>
> How did it not work? Was any error message emitted? What is the view
> definition?
I wonder if "not work" means "didn't lock the rows" and the cause
is simply not having a surrounding transaction.
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chester c young | 2006-01-16 18:49:44 | best way for constants in the database |
| Previous Message | Alvaro Herrera | 2006-01-16 17:05:15 | Re: For update |