Re: [HACKERS] In RULEs, INSERT does not use DEFAULTs

2005-06-14 Thread Jaime Casanova
On 6/12/05, Tom Lane <[EMAIL PROTECTED]> wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > I believe this isn't just my problem. Without access to a the > > underlying column's DEFAULT, how can people implement the automated > > WRITEable VIEWs? > > That's a reasonable question, but translati

Re: [HACKERS] In RULEs, INSERT does not use DEFAULTs

2005-06-12 Thread David Fetter
On Sun, Jun 12, 2005 at 11:48:29PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > I believe this isn't just my problem. Without access to a the > > underlying column's DEFAULT, how can people implement the automated > > WRITEable VIEWs? > > That's a reasonable question, but

Re: [HACKERS] In RULEs, INSERT does not use DEFAULTs

2005-06-12 Thread Rod Taylor
On Sun, 2005-06-12 at 20:33 -0700, David Fetter wrote: > On Sun, Jun 12, 2005 at 10:56:22PM -0400, Tom Lane wrote: > > David Fetter <[EMAIL PROTECTED]> writes: > > > At one time, INSERTing a NULL into a column with a DEFAULT used to > > > INSERT the DEFAULT. Is there some way to get this behavior

Re: [HACKERS] In RULEs, INSERT does not use DEFAULTs

2005-06-12 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > I believe this isn't just my problem. Without access to a the > underlying column's DEFAULT, how can people implement the automated > WRITEable VIEWs? That's a reasonable question, but translating "insert null" to "insert the default" is not a reasonable

Re: [HACKERS] In RULEs, INSERT does not use DEFAULTs

2005-06-12 Thread David Fetter
On Sun, Jun 12, 2005 at 10:56:22PM -0400, Tom Lane wrote: > David Fetter <[EMAIL PROTECTED]> writes: > > At one time, INSERTing a NULL into a column with a DEFAULT used to > > INSERT the DEFAULT. Is there some way to get this behavior back? > > PG has *never* done that in any version that I can r

Re: [HACKERS] In RULEs, INSERT does not use DEFAULTs

2005-06-12 Thread Tom Lane
David Fetter <[EMAIL PROTECTED]> writes: > At one time, INSERTing a NULL into a column with a DEFAULT used to > INSERT the DEFAULT. Is there some way to get this behavior back? PG has *never* done that in any version that I can recall, and it isn't likely that we would install such an obvious vio

[HACKERS] In RULEs, INSERT does not use DEFAULTs

2005-06-12 Thread David Fetter
Folks, At one time, INSERTing a NULL into a column with a DEFAULT used to INSERT the DEFAULT. Is there some way to get this behavior back? I think that this is a bug introduced by removing the NULL -> DEFAULT behavior and not replacing it somehow. Below is a simple repro. I think this is a bug