Request a Demo
Home   >   mailing lists

Re: Two sequences associated with one identity column - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Two sequences associated with one identity column
Date
Msg-id 4c41582a-83ee-4500-abde-e44a0f3d3895@aklaver.com
Whole thread Raw
In response to Re: Two sequences associated with one identity column  ("Colin 't Hart" <colinthart@gmail.com>)
Responses Re: Two sequences associated with one identity column
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Colin 't Hart"
Date:
Subject: Re: Two sequences associated with one identity column
Next
From: Rumpi Gravenstein
Date:
Subject: Re: Two sequences associated with one identity column