Hello Fadila,

In the next coming feature release, it will also be possible to pass a list of columns to COPY INTO .. FROM STDIN, e.g.:

COPY ... INTO mytable from STDIN (col2, col3, col4) USING DELIMITERS ...;

This will solve the current dilemma with COPY INTO...FROM STDIN and auto increment columns.

With kind regards,

Jennie

On Mar 27, 2015, at 08:38, fadila.mumbasic@uniserv.com wrote:

Hi,

We are facing problems with COPY INTO .. FROM STDIN and an auto increment column, which is the primary key column in the table. The client is our own java client.

If we don't set any value for this column (which is our expected constellation) there is neither error nor exception, but no record is inserted into the table.

A try with a null value for this column produces the same result (no exception, no record in the table)

The only way to insert records is to set the proper value for the column, but it is not the supposed behavior of an auto increment column, isn't it?

Best regards, Fadila

---

users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list