| From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Jaime Casanova <systemguards(at)gmail(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: updatable views and default values |
| Date: | 2006-09-02 23:22:49 |
| Message-ID: | 20060902232249.GO84229@nasby.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Aug 31, 2006 at 06:29:50PM -0400, Tom Lane wrote:
> For backwards compatibility we should probably say that this automatic
> lifting of base-table defaults happens only if the INSERT rule is
> implicitly generated ... if you write a manual INSERT rule you need
> manual defaults too. Or should "propagate default values" become an
> explicit attribute of ON INSERT rules?
ISTM that least surprise dictates that inserting into a view uses the
base table default unless you specifically override them.
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-09-02 23:34:28 | Re: [HACKERS] DOC: catalog.sgml |
| Previous Message | Bruce Momjian | 2006-09-02 23:12:45 | Re: [COMMITTERS] pgsql: Revert change to turn |