Typed Errors

[ghost]

I'm using SELECT FOR UPDATE NOWAIT for locking a row and preventing concurrent updates. When a concurrent transaction tries to select the same row that's been locked by another transaction for update, I'd like to return a different error code to the client as opposed to the generic internal server failure that is returned for any other failure. Is there a way to achieve that in sqlc ? Does the generated queries go code return a different type of error for this case ?

[ghost]

The current approach is relying on the pq driver:

pqError, ok := err.(*pq.Error)

if ok && pqError.Code == ERROR_CODE_LOCK_NOT_AVAILABLE {
	return nil, &ConcurrentUpdateError{}
}