Re: ANSI Compliant Inserts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Loftis <mloftis(at)wgops(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Rod Taylor <rbt(at)zort(dot)ca>, pgsql-patches(at)postgresql(dot)org
Subject: Re: ANSI Compliant Inserts
Date: 2002-04-15 05:27:54
Message-ID: 7836.1018848474@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Michael Loftis <mloftis(at)wgops(dot)com> writes:
> IMHO, from a developers/users prospective I want to get atleast a NOTICE
> when they mismatch, and really preferably I want the query to fail
> because if I'm naming a column list then forget a value for it something
> is wrong...

So far I think everyone agrees that if an explicit column name list is
given, then it should fail if the column values don't match up. But
what do you think about the case with no column name list?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Curt Sampson 2002-04-15 05:45:02 Re: 7.3 schedule
Previous Message Michael Loftis 2002-04-15 05:12:36 Re: ANSI Compliant Inserts

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2002-04-15 05:30:57 Re: Commands/ directory reorganisation
Previous Message Joe Conway 2002-04-15 05:18:13 Re: contrib/dblink update