tree 2a781997abd04889b5d5c7a5881d39eb078369bf
parent c9b337eb07c79f30c235b0649b0ce1b7e0c3e30c
author Jonathan Amsterdam <jba@google.com> 1606919138 -0500
committer Jonathan Amsterdam <jba@google.com> 1606935565 +0000

internal/database: add a test showing that pgx copy only inserts

The fast pgx CopyFrom function can only insert new rows; it does not
upsert (that is, replace existing rows). A new test demonstrates that
by copying a row with an existing primary key, and getting a
constraint violation.

This means, unfortunately, that we can't use copy for anything where
we could really use the extra speed.

However, it's still worth switching to pgx because it's still a bit
faster than lib/pq, and it's better maintained.

Change-Id: Ib11c6a80fc04cdc88d59f48f51b175b0722c4e65
Reviewed-on: https://go-review.googlesource.com/c/pkgsite/+/274215
Trust: Jonathan Amsterdam <jba@google.com>
Run-TryBot: Jonathan Amsterdam <jba@google.com>
Reviewed-by: Julie Qiu <julie@golang.org>