Skip site navigation (1) Skip section navigation (2)

Re: ANSI Compliant Inserts

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Rod Taylor <rbt(at)zort(dot)ca>, pgsql-patches(at)postgresql(dot)org
Subject: Re: ANSI Compliant Inserts
Date: 2002-04-15 03:37:20
Message-ID: 200204150337.g3F3bKr22543@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> >> In general I'm suspicious of rejecting cases we used to accept for
> >> no good reason other than that it's not in the spec.  There is a LOT
> >> of Postgres behavior that's not in the spec.
> 
> > TODO has:
> >     o Disallow missing columns in INSERT ... VALUES, per ANSI
> 
> Where's the discussion that's the basis of that entry?  I don't recall
> any existing consensus on this (though maybe I forgot).

I assume someone (Peter?) looked it up and reported that our current
behavior was incorrect and not compliant.  I didn't do the research in
whether it was compliant.

> There are a fair number of things in the TODO list that you put there
> because you liked 'em, but that doesn't mean everyone else agrees.
> I certainly will not accept "once it's on the TODO list it cannot be
> questioned"...

I put it there because I didn't think there was any question.  If I was
wrong, I can add a question mark to it.

Do you want to argue we should continue allowing it?  Also, what about
missing trailling columns in COPY?

If we continue allowing missing INSERT columns, I am not sure we can
claim it is an extension or whether the standard requires the query to
fail.

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

In response to

Responses

pgsql-hackers by date

Next:From: Rod TaylorDate: 2002-04-15 03:39:01
Subject: Re: ANSI Compliant Inserts
Previous:From: Tom LaneDate: 2002-04-15 03:26:25
Subject: Re: ANSI Compliant Inserts

pgsql-patches by date

Next:From: Rod TaylorDate: 2002-04-15 03:39:01
Subject: Re: ANSI Compliant Inserts
Previous:From: Magnus Naeslund(f)Date: 2002-04-15 03:35:51
Subject: Win32 Error descriptions + config

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group