Fixed it, nothing fancy...
Apparently Postgres can't keep generating uniques NEXTVALs for id numbers unless an insert is committed to the table. Apparently the problem occurs when you use transactions, so I commented out the begin_sql and commit orders and that fixed the problem.
Is this a bug ???
This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.