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

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Bug or feature? COPY ignores column defaults
Date: 1999-01-28 14:11:51
Message-ID: 36B07027.4CEEE72E@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Vadim

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Reiner Nippes 1999-01-28 14:22:30 (Fwd) Re: [ADMIN] Running Postgres on a HP-Ux 10.10 System
Previous Message Oliver Elphick 1999-01-28 13:28:33 Bug or feature? COPY ignores column defaults