I have migrated a Servoy 4 solution to Servoy 7, Sybase to Postgres, and everything is more or less okay.
I do have one problem though which is that I have a pk on one table which, when in Sybase was started at 16000, and has now grown to 18000+.
In Postgres I have to make it continue from the next id (18124), but it is continuing from the next max id (2k something).
The PK is a servoy sequence, not a db sequence, so I cannot use pgadmin to do a
ALTER SEQUENCE my_pk_id RESTART WITH 18124
Servoy developer no longer has the ability to set the start point of a sequence (which was how I set it to 16000 in the first place)
Anybody got the answer that I am looking for?
Thanks.
Bevil