<Summarize your issues here>Problem Inserting Data in a Table with Autoincrement id -postgresql2 0.5.1.

[sortie]

From @finsignaresv on August 15, 2018 18:18

URL: https://pub.dartlang.org/packages/postgresql2#-installing-tab-

There is an error when somebody try to insert data in a table that has an autoincrement id:

I/flutter ( 1922): Query error: pgpool9:30264:9 ERROR 23505 duplicate key value violates unique constraint "table_pkey".

Is possible to insert the first row in the table, but if you try to upload a second one you will have this error, because the id do not increase automatically.

I hope you can fix this error soon.

Best regards,

Francisco.

Copied from original issue: dart-lang/pub-dev#1531

[tomyeh]

It is application's job, not driver's. Basically, you can use upsert or update-then-insert-with-query to avoid it.