pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

Empty AUTOINCREMENT postresql sequence if there is no rows in a sqlite table

Open thenik opened this issue 2 years ago • 0 comments

  • [x] pgloader --version pgloader version "3.6.999791d" compiled with SBCL 2.1.11.debian

  • [x] did you test a fresh compile from the source tree? yes, I compiled after "git clone"

  • [x] did you search for other similar issues? yes , I found a similar issue https://github.com/dimitri/pgloader/issues/882 but it has the different reason

  • [x] how can I reproduce the bug? Empty AUTOINCREMENT postresql sequence if there is no rows in a source sqlite table

sample table in sqlite with autoincrement key image

how it was migrated to pstgresql image

and here is an error that I got from the code image

23502: null value in column "id" of relation "translations" violates not-null constraint

Any ideas how to adjust it via pgloader ? Thanks!

thenik avatar Aug 11 '23 08:08 thenik