| From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
|---|---|
| To: | robertmhaas(at)gmail(dot)com |
| Cc: | thomas(dot)munro(at)enterprisedb(dot)com, nagata(at)sraoss(dot)co(dot)jp, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] [PATCH] Lockable views |
| Date: | 2018-02-06 06:28:51 |
| Message-ID: | 20180206.152851.1477076427263493402.t-ishii@sraoss.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> But what does that have to do with locking?
Well, if the view is not updatable, I think there will be less point
to allow to lock the base tables in the view because locking is
typically used in a case when updates are required.
Of course we could add special triggers to allow to update views that
are not automatically updatable but that kind of views are tend to
complex and IMO there's less need the automatic view locking feature.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajkumar Raghuwanshi | 2018-02-06 06:32:51 | Re: Query running for very long time (server hanged) with parallel append |
| Previous Message | Amit Khandekar | 2018-02-06 06:26:27 | Re: Query running for very long time (server hanged) with parallel append |