Problem Inserting Postgres
goravanis at gmail.com
Sat Jul 9 17:43:58 UTC 2022
I figured out my insert problem.
It was that my table was not created correctly.
You have to mark your primary key column as a Field Type Sequence for it to insert the word SERIAL for that columns datatype in Postgres
So once I did that, and added primary key to that column in my table definition
My insert worked right away.. there was nothing wrong with it
And my returning clause worked, I got back my primary key value
So I’m good to go, thanks anyways !
More information about the omnisdev-en