Re: Two sequences associated with one identity column

I've seen two indexes created on the same table/column when you create a
primary key as part of table create ddl and then also run a separate create
index statement for the same table/column.

On Thu, Oct 30, 2025 at 10:42 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 10/30/25 01:55, Colin 't Hart wrote:
> > relname | relnamespace | relpersistence
> > --------------------------+--------------+----------------o
> > <sequence1> | 524799410 | p
> > <sequence2> | 524799410 | p
> > (2 rows)
> >
>
> Well so much for that guess. I was exploring the idea that the sequence
> may have been unlogged at some point and you had both a logged(p) and
> unlogged(u) instance of each.
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
>

--
Rumpi Gravenstein