Problem Inserting Postgres

Das Goravani goravanis at
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 mailing list