For update

From: Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: For update
Date: 2006-01-16 16:59:33
Message-ID: 34608c0c0601160859g4e077ad9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

What does this do exactly:

select * from <ViewName> where <condition> for update;

Will be locked all the tuples in all tables it retrieves?

In 8.0.5 this did not work for me.

Thanks,
Otto

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Seltenreich 2006-01-16 17:02:25 Re: psql client: technique for applying default values to :variables?
Previous Message Jeff Boes 2006-01-16 15:33:39 Re: psql client: technique for applying default values to :variables?