Posts tagged as 'postgres'

How to reset the primary key sequence when it falls out of sync in Postgres?

In this post, I look at how we can fix the "duplicate key value violates unique constraint" error because the sequence is out of sync from the records in the table.

Read post ›

How to write a query with the IN operator using Dapper and NPGSql

In this post, I look at what changes need to be made to write a query with the IN operator in a WHERE clause using Dapper and NPGSql

Read post ›
Ankur Sheel © 2021
Connect with me
GithubTwitterLinkedIn