Re: Two sequences associated with one identity column
| От | Rumpi Gravenstein |
|---|---|
| Тема | Re: Two sequences associated with one identity column |
| Дата | |
| Msg-id | CAEpg1wBP7U6CiaJFz1LeH3A01jRgg6iZsyrmFk_jEHKfWgesdg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Two sequences associated with one identity column (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: Two sequences associated with one identity column
|
| Список | pgsql-general |
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 AM Adrian Klaver <adrian.klaver@aklaver.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
Rumpi Gravenstein
В списке pgsql-general по дате отправления: