Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: [PATCHES] ANSI Compliant Inserts

Re: [PATCHES] ANSI Compliant Inserts

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.net> writes:
> I recall that this was the behavior we agreed we wanted.  IMHO, it would
> be conditional on the INSERT ... VALUES (DEFAULT) capability being
> provided.  I'm not sure if that is there yet.

That is there now.  Do you recall when this was discussed before?
I couldn't remember if there'd been any real discussion or not.
        regards, tom lane

Re: [PATCHES] ANSI Compliant Inserts

From
Vince Vielhaber
Date:
On Mon, 15 Apr 2002, Tom Lane wrote:

> Peter Eisentraut <peter_e@gmx.net> writes:
> > I recall that this was the behavior we agreed we wanted.  IMHO, it would
> > be conditional on the INSERT ... VALUES (DEFAULT) capability being
> > provided.  I'm not sure if that is there yet.
>
> That is there now.  Do you recall when this was discussed before?
> I couldn't remember if there'd been any real discussion or not.

It has to be at least a year, Tom.  I brought it up in hackers after
I got bit by it.  I had a rather long insert statement and missed a
value in the middle somewhere which shifted everything by one.  It
was agreed that it shouldn't happen but I don't recall what else was
decided.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net        56K Nationwide Dialup from $16.00/mo
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================

Re: [PATCHES] ANSI Compliant Inserts

From
Bruce Momjian
Date:
Vince Vielhaber wrote:
> On Mon, 15 Apr 2002, Tom Lane wrote:
> 
> > Peter Eisentraut <peter_e@gmx.net> writes:
> > > I recall that this was the behavior we agreed we wanted.  IMHO, it would
> > > be conditional on the INSERT ... VALUES (DEFAULT) capability being
> > > provided.  I'm not sure if that is there yet.
> >
> > That is there now.  Do you recall when this was discussed before?
> > I couldn't remember if there'd been any real discussion or not.
> 
> It has to be at least a year, Tom.  I brought it up in hackers after
> I got bit by it.  I had a rather long insert statement and missed a
> value in the middle somewhere which shifted everything by one.  It
> was agreed that it shouldn't happen but I don't recall what else was
> decided.

Yes, I do remember Vince's comment, and I do believe that is the time it
was added.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026