Re: BUG #14952: COPY fails to fill in IDENTITY column default value

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: steven(dot)winfield(at)cantabcapital(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14952: COPY fails to fill in IDENTITY column default value
Date: 2017-12-07 17:13:53
Message-ID: 12618e2c-0eb0-3e15-c45d-96891c52eb5f@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 12/7/17 06:29, steven(dot)winfield(at)cantabcapital(dot)com wrote:
> COPYing data to a table with an IDENTITY column, where the column's value
> isn't specified in the copied input, fails because COPY attempts to insert a
> NULL value for the column:

That indeed appears to be a bug.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message François CHAHUNEAU 2017-12-07 17:39:05 Re: [BUGS] pg_trgm word_similarity inconsistencies or bug
Previous Message Bernd Helmle 2017-12-07 15:47:18 PostgreSQL crashes with SIGSEGV