| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "Yorwerth, Adam" <Adam(dot)Yorwerth(at)tesco(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "Cianciaruso, Lorenzo" <lorenzo(dot)cianciaruso(at)tesco(dot)com> |
| Subject: | Re: BigSerial and txid issuance |
| Date: | 2020-07-08 15:25:23 |
| Message-ID: | CAKFQuwaUTFc8+fFxGM5bdxucj2aDVTmnx8tOy9vOj=umGUSmRw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Jul 8, 2020 at 8:18 AM Yorwerth, Adam <Adam(dot)Yorwerth(at)tesco(dot)com>
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 of the disclaimers about serial value issuance you should assume
that it is possible.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-07-08 16:20:52 | Re: BigSerial and txid issuance |
| Previous Message | FOUTE K. Jaurès | 2020-07-08 15:01:06 | Re: PostgreSQL 12 - ERROR: could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device |