Hello @potrusil

Currently, sqlserver2pgsql does not support IDENTITY columns and use sequences. There is an open issue about this (#102).
When a sequence is created in PostgreSQL, the default minvalue is 1. To be able to create a sequence holding negative values, you must update the sequence used in the table. For example:

=# CREATE TABLE table_negative_id (id serial PRIMARY KEY, value integer);
CREATE TABLE
=# \d table_negative_id
                               Table « public.table_negative_id »
 Colonne |  Type   | Collationnement | NULL-able |                  Par défaut                   
---------+---------+-----------------+-----------+-----------------------------------------------
 id      | integer |                 | not null  | nextval('table_negative_id_id_seq'::regclass)
 value   | integer |                 |           | 
Index :
    "table_negative_id_pkey" PRIMARY KEY, btree (id)
=# ALTER SEQUENCE table_negative_id_id_seq MINVALUE -1000000001 START -1000000000 RESTART -1000000000;
ALTER SEQUENCE
=# INSERT INTO table_negative_id (value) VALUES (1), (2), (3);
INSERT 0 3
=# SELECT * FROM table_negative_id;
     id      | value 
-------------+-------
 -1000000000 |     1
  -999999999 |     2
  -999999998 |     3
(3 lignes)

Does this trick solve your problem?

Cordialement,

Uh oh!

Negative arguments to IDENTITY #112

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions