Views and locks

From: "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Views and locks
Date: 2001-10-17 18:29:23
Message-ID: 002b01c15739$a75c9720$6e646464@New6.Travel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-general by date

  From Date Subject
Next Message Jon Lapham 2001-10-17 18:45:05 yet another db corruption issue
Previous Message samsom, debra 2001-10-17 18:14:27 Re: postgresql 7.1.3