Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] COPY with default values won't work? - Mailing list pgsql-general

From Vadim Mikheev
Subject Re: [GENERAL] COPY with default values won't work?
Date
Msg-id 36F89C9D.3F7D123F@krs.ru
Whole thread Raw
In response to Re: [GENERAL] COPY with default values won't work?  ("K.T." <kanet@calmarconsulting.com>)
Responses Re: [GENERAL] COPY with default values won't work?
List pgsql-general
Tree view 
"K.T." wrote:
>
> Or instead of eating tons of memory inserting all those record in one
                ^^^^^^^^^^^^^^^^^^^^^
I think this was fixed ~ 1.5-2 years ago...

> transaction (you might want to commit every hundred or so...), copy then
> issue an update to set the default values.

Oh, no. Remember that Postgres is non-overwriting storage system.

Vadim

pgsql-general by date:

Previous
From: "K.T."
Date:
Subject: Re: [GENERAL] COPY with default values won't work?
Next
From: Oleg Broytmann
Date:
Subject: Re: [GENERAL] COPY with default values won't work?