Re: auto-increment with postgresql

Hi Jeff,

On 20.03.20 17:40, Jeffery Painter wrote:
> The torque template generator is creating sequences for auto-increment
> primary keys, however, I think there is a flaw in the logic setup.

The management of sequences is done within the Torque Java code and not
in SQL. When Torque was designed, the features you describe probably
didn't exist. Please check if the code works without your manual changes
(it should). If it doesn't, please create an issue in the Torque project.

My guess is that in your setup nextval() is going to be called twice,
once by the default clause in your table column and once by the Java
code in Torque. That means that you ids will increment by two every
time. Could you please verify that?

Generally, my intention was to modernize the Torque code for 5.0. If the
ownership of a sequence is now a recommended best practice, we should
add that to the Torque templates.

Bye, Thomas