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);
CREATE TABLE
postgres=# insert into tab_always values(1, 10);
ERROR: cannot insert into column "i"
DETAIL: Column "i" is an identity column defined as GENERATED ALWAYS.
HINT: Use OVERRIDING SYSTEM VALUE to override.
[ashu@localhost bin]$ cat /tmp/always.csv
13 10
14 20
15 30
16 40
postgres=# copy tab_always from '/tmp/always.csv';
COPY 4
postgres=# select * from tab_always;
i | j
----+----
13 | 10
14 | 20
15 | 30
16 | 40
(4 rows)
--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com