How unique PK value in Postgres?

Doug Easterbrook doug at
Tue Feb 1 22:19:05 UTC 2022

I don’t see what the issue is.

in omnis, you have to declare an auto-incrementing field as seq

in sqllite, you have to declare it as autoincrement

in postgres, you declare it as either SERIAL or BIGSERIAL.  (or you build your own since default values can be used for things  you haven’t thought of yet .   maybe you want your foreign keys to be only even numbers,     maybe you want postgres to grab a 100 at a time and cache them).

so, in my mind, exactly the same, just different words.

just because its new or different, doesn’t make it hard.   we just have to learn the dialect of SQL

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at
Phone (403) 650-1978

> On February 1, 2022, at 2:05 PM, Das Goravani <goravanis at> wrote:
> Thank you Alan, Alex and Doug. I now have enough to use the docs for anything more. I wouldn’t have believed this if I just read it in the docs.. I would think I’m having an existential moment. I can’t believe it, what you have to do to get this.. 

More information about the omnisdev-en mailing list