Re: Advice on Contiguous IDs

2018-01-09 Thread Vik Fearing
On 01/09/2018 10:06 AM, Brian McKiernan wrote: > Hi Folks, > > Looking for some help/advice - not sure if this is the appropriate channel. It is not. You want the pgsql-general list, or perhaps pgsql-novice. > My Issue: > My primary keys in a certain table are not contiguous. Is that really an

Re: Advice on Contiguous IDs

2018-01-09 Thread Steve Atkins
> On Jan 9, 2018, at 1:06 AM, Brian McKiernan > wrote: > > > Hi Folks, > > Looking for some help/advice - not sure if this is the appropriate channel. pgsql-general would be a better bet. > > My Issue: > My primary keys in a certain table are not contiguous. That itself isn't a problem at

Re: Advice on Contiguous IDs

2018-01-09 Thread David G. Johnston
On Tue, Jan 9, 2018 at 2:06 AM, Brian McKiernan < brian.mckier...@firstcircle.com> wrote: > 1) What event would cause the CACHE clause in CREATE SEQUENCE to make an > out of sequence next number? > ​None - it will always issue the next sequential value when asked. But the transaction asking does

Re: libpq options

2018-01-09 Thread Vik Fearing
On 11/28/2017 09:21 AM, Michael Paquier wrote: > On Tue, Nov 28, 2017 at 5:00 PM, Şahap Aşçı wrote: >> I think this solves the consistency issue that i am talking about. Well, i >> am just looking from documentation user point of view. > > Thanks. Input is always welcome. I have added an entry i

Re: Advice on Contiguous IDs

2018-01-09 Thread Alvaro Herrera
Brian McKiernan wrote: > My Issue: > My primary keys in a certain table are not contiguous. If you have a need to have values that are contiguous, you need to ask yourself why and then see what mechanism provides the semantics you need. An easy way is to lock the table containing the column, for

Advice on Contiguous IDs

2018-01-09 Thread Brian McKiernan
Hi Folks, Looking for some help/advice - not sure if this is the appropriate channel. My Issue: My primary keys in a certain table are not contiguous. What I have done so far: I have checked the documentation and found:  https://wiki.postgresql.org/wiki/FAQ#Why_are_there_gaps_in_the_numbering_of

Describe UNION's cast on derived table

2018-01-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/typeconv-union-case.html Description: Hi! Whilst the type conversion works great on the query ;select 10 as col1 union select null as col1;, it does not on the almost same one ;sel