public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Brian McKiernan <[email protected]>
Cc: [email protected]
Subject: Re: Advice on Contiguous IDs
Date: Tue, 9 Jan 2018 09:57:50 -0700
Message-ID: <CAKFQuwbPWiAqu63fs3Ldx_ShaeBTYVmuGhR-E=yGDPVFv2qWXw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

On Tue, Jan 9, 2018 at 2:06 AM, Brian McKiernan <
[email protected]> 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 doesn't have to use the provided value as the PK for the
table or, and even if it does, if the transaction fails and rolls-back the
sequence value it received is discarded/lost.​
​
​David J.​
​

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Advice on Contiguous IDs
  In-Reply-To: <CAKFQuwbPWiAqu63fs3Ldx_ShaeBTYVmuGhR-E=yGDPVFv2qWXw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox