| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Fernando Nasser <fnasser(at)cygnus(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Neil Padgett <npadgett(at)redhat(dot)com>, "pgsql-patches(at)postgresql(dot)org" <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: Revised Patch to allow multiple table locks in "Unison" |
| Date: | 2001-08-02 23:26:19 |
| Message-ID: | 14668.996794779@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Fernando Nasser <fnasser(at)cygnus(dot)com> writes:
> BTW, it seems we have a SQL non-conformance issue here: views that are
> only projections+selections of a single base table are SQL-updatable.
Indeed. In Postgres terms I think this means that if a CREATE VIEW
describes a view that meets the spec's constraints to be "updatable",
we should automatically create a default set of insert/update/delete
rules for it. This is (or should be) on the TODO list.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-08-02 23:37:57 | Re: Re: OID wraparound: summary and proposal |
| Previous Message | Tom Lane | 2001-08-02 23:18:44 | Re: pg_dumpall problem in 7.1 and cvs |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-08-02 23:30:02 | Re: Patch for Improved Syntax Error Reporting |
| Previous Message | Neil Padgett | 2001-08-02 23:08:07 | Re: Patch for Improved Syntax Error Reporting |