Re: [HACKERS] Bug or feature? COPY ignores column defaults

>
> Oliver Elphick wrote:
> >
> > At release 6.4.2, COPY does not respect column defaults:
> >
> > INSERT works correctly, however.
> >
> > Is this intentional, or a bug?
>
> This is standard behaviour. DEFAULT value is sabstituted
> only if column value (including NULL) is not specified in
> INSERT statement.

And so for the rule system. It is not invoked on COPY, so
rewrite rules don't take effect.

If you want some columns to have defaults assigned when the
value in COPY is NULL, or maybe override something like a
timestamp field, you could define a trigger. Triggers are
called from COPY.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #