Postgres Pro
Downloads
Home   >   mailing lists

Re: Field with default not being set on copy from. - Mailing list pgsql-general

From Tom Lane
Subject Re: Field with default not being set on copy from.
Date
Msg-id 11957.1041631487@sss.pgh.pa.us
Whole thread Raw
In response to Re: Field with default not being set on copy from.  (Jean-Luc Lachance <jllachan@nsd.ca>)
List pgsql-general
Tree view 
Jean-Luc Lachance <jllachan@nsd.ca> writes:
> The last part of my message should have read:
> I am running 7.2.3

Ah.  In that case, you are right: COPY fills missing fields with nulls,
not default values.  This is fixed in 7.3.

            regards, tom lane

pgsql-general by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Field with default not being set on copy from.
Next
From: Steve Crawford
Date:
Subject: Re: How to backup a postgreSQL of 80 GByte ?