Re: ANSI Compliant Inserts

Tom Lane wrote:

>
>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?
>
I'm on the fence in that situation. Though I'd lean towards a patch
thats a sort of compromise. IIF the 'remaining' columns (IE columns
unspecified) have some sort of default or auto-generated value (forgive
me I'm just getting back into workign with postgresql) like a SERIAL or
TIMESTAMP allow it, IFF any of them do not have a default value then
fail. This will make it 'do the right thing' -- it's not exactly what
the spec does, but it's close to the current behavior that several
others (including myself) see as beneficial in the case of interactive use.

As far as implementation of this sort of compromise, I'm not sure, but
it hsould be possible, assuming the planner knows/flags triggers on
column inserts and can make decisions and reject the query based on that
information (I don't think that information would be in the parser)

>
>
> regards, tom lane
>