Table Partitioning: Sequence jump issue 10 in 10 with serial datatype

From: DrakoRod <drakoflames(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype
Date: 2018-02-14 00:27:06
Message-ID: 1518568026195-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-02-14 01:38:18 Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype
Previous Message Tom Lane 2018-02-13 23:46:25 Re: I do not get the point of the information_schema