On Wed, 2020-07-08 at 14:09 +, Yorwerth, Adam wrote:
> We’re trying to solve a problem that relies on BigSerial and txid (as
> returned by txid_current() ) values being issued consistently.
>
> Is it possible for two transactions to interleave their issuance of these two
> variables?
>
>
On 7/8/20 7:09 AM, Yorwerth, Adam wrote:
Hi Everyone,
We’re trying to solve a problem that relies on BigSerial and txid (as
returned by txid_current() ) values being issued consistently.
Is it possible for two transactions to interleave their issuance of
these two variables?
For example:
On Wed, Jul 8, 2020 at 8:18 AM Yorwerth, Adam
wrote:
> Is it possible for two transactions to interleave their issuance of these
> two variables?
>
>
>
> Is it possible for transaction 1 to be issued txid 1001 and offset 12 and
> transaction 2 to be issued txid 1002 and offset 11?
>
Given all
Hi Everyone,
We’re trying to solve a problem that relies on BigSerial and txid (as returned
by txid_current() ) values being issued consistently.
Is it possible for two transactions to interleave their issuance of these two
variables?
For example:
Schema:
CREATE TABLE EXAMPLE(
offset
