How unique PK value in Postgres?

[Das Goravani]

> On Feb 1, 2022, at 5:19 PM, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> 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
> 
> 
This was a really good post, very right on.
I tend to fear that which is new to me.
SQL requires that I keep constant notes about new SQL I’ve come across.
I’m just not used to this way yet.
But I’m getting there. 
Not used to Terminal either. 
This world of "bigger time computing" is a bit daunting at first.
But you’re totally right.. "we just have to learn the dialect of SQL"
You directly make my life better, thank you so much.
> 
> 
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
> 
>> On February 1, 2022, at 2:05 PM, Das Goravani <goravanis at gmail.com> 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.. 
> 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com