db sequences creation when import a solution (server)

Classic Servoy
1

Hi.

In the developer when a field is created with the Sequence Type db seq, it creates the new sequence in the db (postgre). That’s ok.
But if I import the solution in the application server (with an empty db, so it create all tables and fields) it doesn´t create the sequence in the db.
In the .dbi I have

allowNull:false,
autoEnterSubType:1,
autoEnterType:2,
creationOrderIndex:0,
dataType:4,
databaseSequenceName:"seq_tests_test_id",
flags:1,
name:"test_id"
}

and in the repository I found in the servoy_columninfo table

     columnname |  auto_enter_type |  system_value     | db_sequence_name  |
----------------+------------------+-------------------+-------------------|
test_id         | 2                | 1                 | seq_tests_test_id |

That seems to be the same (if the autoEnterType of the dbi is the system_value of the repository )… so is a bug in the import or the expected behavior?

2

Should the application server create the db sequences in the import?

3

Hi Victor,

Yes, the server should create the db sequences at import.
We will fix this next 5.2 release.

You can create the missing db sequences for postgres using sql:

create sequence mysequence

Rob

4

Ok, thanks Rob!