Postgres Pro
Downloads
Home   >   mailing lists

Re: Partitioning, Identity and Uniqueness (given pg 16 changes) - Mailing list pgsql-general

From David G. Johnston
Subject Re: Partitioning, Identity and Uniqueness (given pg 16 changes)
Date
Msg-id CAKFQuwaZaS7Y6Tu18b9NPnQqYiWyrS5SRDNMSN4TUvQaHF=Aeg@mail.gmail.com
Whole thread Raw
In response to Re: Partitioning, Identity and Uniqueness (given pg 16 changes)  (Darryl Green <darryl.green@gmail.com>)
Responses Re: Partitioning, Identity and Uniqueness (given pg 16 changes)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Monday, February 19, 2024, Darryl Green <darryl.green@gmail.com> wrote:

> It may be possible to still have it work by doing a speculative record
> in the index for the target table then go and check all of the other
> indexes before marking the speculative entry as valid.

It is always valid - except in the OVERRIDING SYSTEM VALUE case - no?

 False.

ALTER TABLE … ALTER id RESTART 1;

David J.

pgsql-general by date:

Previous
From: gparc@free.fr
Date:
Subject: Re: Users and object privileges maintenance
Next
From: "David G. Johnston"
Date:
Subject: Re: Partitioning, Identity and Uniqueness (given pg 16 changes)