Open thenik opened 1 year ago
[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
how it was migrated to pstgresql
and here is an error that I got from the code
23502: null value in column "id" of relation "translations" violates not-null constraint
Any ideas how to adjust it via pgloader ? Thanks!
[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
how it was migrated to pstgresql
and here is an error that I got from the code
23502: null value in column "id" of relation "translations" violates not-null constraint
Any ideas how to adjust it via pgloader ? Thanks!