# auto-enter value (sequences) won't stick **URL:** \ **Category:** Classic Servoy\ **Created:** [February 13, 2007, 10:43pm UTC](https://forum.servoy.com/t/auto-enter-value-sequences-wont-stick/7089 "2007-02-13T22:43:12Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [February 13, 2007, 10:43pm UTC](https://forum.servoy.com/t/auto-enter-value-sequences-wont-stick/7089/1 "2007-02-13T22:43:12Z")
When setting auto-enter values for database sequences they will only stick for the session you have Developer open. During this session you can create records without problems. But after closing and re-launching Developer the auto-enter values of my PK columns are set to database managed values. A setting that is not compatible with the used RDBMS and/or JDBC driver. For developers like me who use **only** database sequences this is a showstopper. Servoy Developer Version 3.1.2-build 406 Java version 1.5.0\_06-64 (Mac OS X) RDBMS: PostgreSQL 8.2.3 JDBC driver: postgresql-8.2-504.jdbc3.jar Bugbase case # 67642 ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [February 14, 2007, 9:07am UTC](https://forum.servoy.com/t/auto-enter-value-sequences-wont-stick/7089/2 "2007-02-14T09:07:58Z")
We have not been able to reproduce the problem. We created a new table on a Postgres db using Developer, pk auto-enter = ‘Sequence, dbseq’, created the sequence in the db backend and were able to create records. After restart of Developer, the settings were unchanged, as expected. A similar test using Sybase and auto-enter db-identity also works as expected. Please check the log files for errors. Rob ---
**Author:** ![swingman](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/swingman/32/4536_2.png) [@swingman](https://forum.servoy.com/u/swingman)\ **Post date:** [February 14, 2007, 12:10pm UTC](https://forum.servoy.com/t/auto-enter-value-sequences-wont-stick/7089/3 "2007-02-14T12:10:18Z")
Hi Rob, Have you tried creating a table in Postgres with a SERIAL column? This will create a sequence. Then try to set this table up in Servoy. We have had intermittent problems with this, when importing a solution onto a new Servoy server or upgrading to 3.0. Several times I have had to reselect all the sequences in the data provider window. Very irritating. Robert, do your pk fields in Postgres have a “Primary Key” constraint? Without this I find Servoy get very confused. ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [February 14, 2007, 12:41pm UTC](https://forum.servoy.com/t/auto-enter-value-sequences-wont-stick/7089/4 "2007-02-14T12:41:58Z")
Hi Christian, Yeah, all my PK columns have a primary key constraint. I use [DbWrench](http://www.dbwrench.com) to design/edit my datamodels. It takes care of all that. In the mean time I have done some more testing. I see the same result when I do a clean install of 3.1.2 and use Sybase as repository server instead of PostgreSQL…so something very strange is going on. Nothing in the logs either. Support got now my JDBC driver, solution and datamodel. We’ll see what comes out of this. Thanks for thinking with me ![:)]( "Smile") ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [February 14, 2007, 3:44pm UTC](https://forum.servoy.com/t/auto-enter-value-sequences-wont-stick/7089/5 "2007-02-14T15:44:46Z")
We still have not been able to reproduce the problem. The solution was imported in postgres, created the tables. The pk auto-enter values can be changed and stick after restart of developer. Rob ---
**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\ **Post date:** [February 16, 2007, 12:44pm UTC](https://forum.servoy.com/t/auto-enter-value-sequences-wont-stick/7089/6 "2007-02-16T12:44:23Z")
Hi, We have been able to locate the problem. There is a small problem in the column-info editor interface. When you use the ‘Properties’ button, changes are not always saved to the database. The workaround is simple: do not use the button, click on the Properties-cell of the column you want to modify. The same dialog appears and changes are saved. The problem will be fixed in next release. Rob