search

pa810p / bps2

Blood Parameters Storage System
GNU General Public License v3.0
1 stars 0 forks source link

After synchronization ids grow too fast #3

Open pa810p opened 1 year ago

pa810p commented 1 year ago

During synchronization (using option: -X sqlite:pgsql) value of id column on blood and sugar tables is growing too fast.

Steps to reproduce:

./blood.sh -p 123/90/80
./blood.sh -p 124/91/81
./blood.sh -p 125/92/82
./blood.sh -X sqlite:pgsql
./blood.sh -p 126/93/83
./blood.sh -p 127/94/84
./blood.sh -p 128/95/85
./blood.sh -X sqlite:pgsql
./blood.sh -e pgsql -q 'SELECT * FROM blood ORDER BY id DESC LIMIT 6;';

Take a look on values on id column. It's not continuous, it contains a gap, why?