MIME-Version: 1.0
References: <CAMon-aTbZC5k2pLpijk5x+h__LV08DzpoJtHBgZGkOKJNJ91pw@mail.gmail.com>
 <aQICcMvkp96kenL8@depesz.com> <CAMon-aTMgbwC9j-wY8iX5kZ4=KXzCXc-Wpwx3viid8hQ_bJkoQ@mail.gmail.com>
 <aQIDbBO0nJTiMd5C@depesz.com> <CAMon-aQ0Zs-Otkp1=zk3WYt7Am-_oQHKEmD_rZ1CNGBAgM_jzw@mail.gmail.com>
 <e1513246-9b04-4beb-ac8e-16a1c2f1ebd5@aklaver.com> <CAMon-aQNPQ86-swjmpiryy3s_yKaWsZbzysrbn7e1xPc3JM3fg@mail.gmail.com>
 <4c41582a-83ee-4500-abde-e44a0f3d3895@aklaver.com>
In-Reply-To: <4c41582a-83ee-4500-abde-e44a0f3d3895@aklaver.com>
From: Rumpi Gravenstein <rgravens@gmail.com>
Date: Thu, 30 Oct 2025 11:22:31 -0400
Message-ID: <CAEpg1wBP7U6CiaJFz1LeH3A01jRgg6iZsyrmFk_jEHKfWgesdg@mail.gmail.com>
Subject: Re: Two sequences associated with one identity column
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "Colin 't Hart" <colinthart@gmail.com>, 
	PostgreSQL General <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000a1437064261d2c3"
Archived-At: <https://www.postgresql.org/message-id/CAEpg1wBP7U6CiaJFz1LeH3A01jRgg6iZsyrmFk_jEHKfWgesdg%40mail.gmail.com>
Precedence: bulk

--0000000000000a1437064261d2c3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFAM Adrian Klaver <adrian.klaver@aklav=
er.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.klaver@aklaver.com
>
>
>

--=20
Rumpi Gravenstein

--0000000000000a1437064261d2c3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">I&#39;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/col=
umn.</div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"=
ltr" class=3D"gmail_attr">On Thu, Oct 30, 2025 at 10:42=E2=80=AFAM Adrian K=
laver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.klaver@aklave=
r.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex">On 10/30/25 01:55, Colin &#39;t Hart wrote:<br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0relname=C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 | relnamespace | relpersistence<br>
&gt; --------------------------+--------------+----------------o<br>
&gt;=C2=A0 =C2=A0&lt;sequence1&gt;=C2=A0 |=C2=A0 =C2=A0 524799410 | p<br>
&gt;=C2=A0 =C2=A0&lt;sequence2&gt;=C2=A0 |=C2=A0 =C2=A0 524799410 | p<br>
&gt; (2 rows)<br>
&gt; <br>
<br>
Well so much for that guess. I was exploring the idea that the sequence <br=
>
may have been unlogged at some point and you had both a logged(p) and <br>
unlogged(u) instance of each.<br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
<br>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature">Rumpi Gravenstein<input type=3D"hidden"><input type=3D"hidden"><d=
iv></div></div></div>

--0000000000000a1437064261d2c3--