Views and locks - Mailing list pgsql-general

From Mihai Gheorghiu
Subject Views and locks
Date
Msg-id 002b01c15739$a75c9720$6e646464@New6.Travel
Whole thread Raw
List pgsql-general
SELECT FOR UPDATE works for views as well?
In other words, can I be sure that the corresponding lock is placed on the
table itself?
If updates are done only via views, can a SELECT FOR UPDATE on a view
prevent simultaneous changes on the record in the original table?


pgsql-general by date:

Previous
From: "samsom, debra"
Date:
Subject: Re: postgresql 7.1.3
Next
From: Jon Lapham
Date:
Subject: yet another db corruption issue