Re: How serial primary key numbers are assigned

2019-04-04 Thread Adrian Klaver
On 4/4/19 11:27 AM, Rich Shepard wrote: On Thu, 4 Apr 2019, Adrian Klaver wrote: See: https://www.postgresql.org/docs/11/sql-createsequence.html Thanks, Adrian. My web searches did not find this URL, only results on how to set up automatic serial id generation. Well serial is basically a m

Re: How serial primary key numbers are assigned

2019-04-04 Thread Rich Shepard
On Thu, 4 Apr 2019, Adrian Klaver wrote: See: https://www.postgresql.org/docs/11/sql-createsequence.html Thanks, Adrian. My web searches did not find this URL, only results on how to set up automatic serial id generation. Regards, Rich

Re: How serial primary key numbers are assigned

2019-04-04 Thread Adrian Klaver
On 4/4/19 11:04 AM, Rich Shepard wrote: Just out of curiosity, how does postgres assign serial primary key identifiers when rows are inserted in multiple, separate working sessions? I'm populating tables using INSERT INTO statements in separate working sessions and see that the assigned id numbe

How serial primary key numbers are assigned

2019-04-04 Thread Rich Shepard
Just out of curiosity, how does postgres assign serial primary key identifiers when rows are inserted in multiple, separate working sessions? I'm populating tables using INSERT INTO statements in separate working sessions and see that the assigned id numbers are sequential in each session, but ha