Re: COPY command on a table column marked as GENERATED ALWAYS

2019-07-28 Thread Ashutosh Sharma
On Mon, Jul 29, 2019 at 7:27 AM Michael Paquier wrote: > > On Fri, Jul 26, 2019 at 03:12:28PM +0530, Ashutosh Sharma wrote: > > Hi All, > > > > I'm able to insert data into a table column marked as GENERATED ALWAYS > > using COPY command however, it fails with INSERT

Re: COPY command on a table column marked as GENERATED ALWAYS

2019-07-28 Thread Michael Paquier
On Fri, Jul 26, 2019 at 03:12:28PM +0530, Ashutosh Sharma wrote: > Hi All, > > I'm able to insert data into a table column marked as GENERATED ALWAYS > using COPY command however, it fails with INSERT command. Isn't that a > bug with COPY command? Per the documentation

COPY command on a table column marked as GENERATED ALWAYS

2019-07-26 Thread Ashutosh Sharma
Hi All, I'm able to insert data into a table column marked as GENERATED ALWAYS using COPY command however, it fails with INSERT command. Isn't that a bug with COPY command? Here is the test-case for more clarity. postgres=# create table tab_always (i int generated always as identity, j int