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