Database synchronize doesn't update sequences

Classic Servoy
1

In the following scenario something goes wrong with inserting sequences in the DB:

  • We have an empty DB
  • We have a solution, with all kinds of tables, columns, and db seq’s specified (in other words, there are .dbi files)
  • In this solution we’ve changed the DB sequence names
  • Clicking on Synchronize DB, gives us the pop-up where we can select ‘Create All’ in order to create all the missing tables and stuff in the empty DB
  • Everything gets created in the DB, but the sequences get the old names instead of the new ones… :(

The dbi files contain the new sequence names. So it looks like Servoy creates the sequence names (and maybe the tables too?) from another file, instead of the dbi files in the workspace.

Doing a file search on the old sequence names, we get results in the following directories:

\application_server\database\base####
\application_server\database\pg_xlog
\servoy_workspace\resources\datasources\solution.svn\text-base\example_table.dbi.svn-base

Is this a bug? And/or is there a refresh possibility in order to let Servoy know that it should update the files it does use for the Create procedure?

Using servoy 5.2.9 - build 1020

2

This is really strange… I’ve just moved all the files in the directories where I found the old names, and still the old sequence names are used when creating all in the DB…

3

Sem,

I see this happening in the code, when a table is created from a dbi-file, the sequence name is not used, this is a bug.
Please create a case in our support system referring to this thread.

Rob

4

case created (#407565).

But the strange behaviour which I thought it did when moving all the files from the directories was a mistake on my behalf (moved the files from a different server :) ). Apart from that, it still doesn’t work correctly as you’ve probably seen in the code.

5

Sem,

This has been fixed in Servoy 6.0.1.

Rob