New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[BUG] Postgresql push insert should fail if primary key exist #197

Open

adrienaury opened this issue Oct 17, 2023 · 1 comment

Member

adrienaury commented Oct 17, 2023 •

edited

Loading

Currently lino silently ignore insertion of object already in database.

This is due to the ON CONFLICT DO NOTHING clause used by the postgresql dataconnector.

Note: with ingress-descriptor this applies to the start table only

The text was updated successfully, but these errors were encountered:

Member Author

adrienaury commented Oct 17, 2023

Additionnaly, the clause ON CONFLICT should be used to implement a lino push upsert action :

ON CONFLICT (pk) DO UPDATE

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment