Solved: Postgres auto increment

Developers Databases
#1

I am working on my first SC project (test) and I am unable to figure out how to get the auto increm. working in postgres. I setup an editable grid and set the PK in “Value in database (insert)” to auto increment (automatic). The grid on insert locks up. The field is incremented by a seq. generator in the database. Any suggestions.

#2

Re: Postgres auto increment

Set it to “Database Defined”. From the documentation:

The field value is assigned by the database . The field is not used in the process of updating. For example: will be updated through a trigger.

HTH

#3

solved: Postgres auto increment

That worked. In the database value of the field: insert - database defined.
Thanks