Re: [HACKERS] Bug or feature? COPY ignores column defaults - Mailing list pgsql-hackers

>
> 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@debis.com (Jan Wieck) #