Version

1.28.0

What happened?

For pgx, pgtype.Timestamp is used for TIMESTAMP (and other time related types) regardless if the column is nullable or not.

time.Time was expected to be used for timestamps marked with NOT NULL

"database/sql" is handling it correctly https://play.sqlc.dev/p/e1e23e0d41d3d1340a4a009099bb81b589385b49187b89fd40c9aee4c33097cf

Database schema

CREATE TABLE authors (
 id BIGSERIAL PRIMARY KEY,
 name text NOT NULL,
 bio text,
 
 born TIMESTAMP NOT NULL,
 died TIMESTAMP
);

SQL queries

-- name: ListAuthors :many
SELECT * FROM authors
ORDER BY name;

Configuration

{
 "version": "2",
 "sql": [{
 "schema": "schema.sql",
 "queries": "query.sql",
 "engine": "postgresql",
 "gen": {
 "go": {
 "out": "db",
 "sql_package": "pgx/v5"
 }
 }
 }]
}

Playground URL

https://play.sqlc.dev/p/7ac654a59b8d17aa0f7e9bd8dfd689bec9d035bc8e8ea7a5a1beb078be531769

What operating system are you using?

No response

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go