Postgres Pro
Downloads
Home   >   mailing lists

Table Partitioning: Sequence jump issue 10 in 10 with serialdatatype - Mailing list pgsql-general

From DrakoRod
Subject Table Partitioning: Sequence jump issue 10 in 10 with serialdatatype
Date
Msg-id 1518568026195-0.post@n3.nabble.com
Whole thread Raw
Responses Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: I do not get the point of the information_schema
Next
From: "David G. Johnston"
Date:
Subject: Re: Table Partitioning: Sequence jump issue 10 in 10 with serial datatype