Table Partitioning: Sequence jump issue 10 in 10 with serialdatatype

Поиск
Список
Период
Сортировка
От DrakoRod
Тема Table Partitioning: Sequence jump issue 10 in 10 with serialdatatype
Дата
Msg-id 1518568026195-0.post@n3.nabble.com
обсуждение исходный текст
Ответы Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Hi folks!!
I have a problem with a serial data type and partitioned table, I used rules
to insert in child tables. But the problem is that the some does'nt insert
and the sequence value jump sometimes 3 in 3 or 10 in 10.

The example is the next:




I don't understand why sequence jumps in this case 4 in 4. And how to avoid
this? I really can't change the use serial data type and how generate the
id, because I don't developed the app.

If I use triggers this don't happen?

Thanks!






-----
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: I do not get the point of the information_schema
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype