Re: Two sequences associated with one identity column

Adrian Klaver <adrian.klaver@aklaver.com>

From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Colin 't Hart <colinthart@gmail.com>
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>
Date: 2025-10-30T14:42:26Z
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.klaver@aklaver.com