Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group