Re: Two sequences associated with one identity column

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Colin 't Hart <colinthart(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Two sequences associated with one identity column
Date: 2025-10-30 14:42:26
Message-ID: 4c41582a-83ee-4500-abde-e44a0f3d3895@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rumpi Gravenstein 2025-10-30 15:22:31 Re: Two sequences associated with one identity column
Previous Message Colin 't Hart 2025-10-30 08:55:12 Re: Two sequences associated with one identity column