cannot use tx (variable of type *sql.Tx) as DBTX value in struct literal: wrong type for method ExecContext

[varian97]

Version

1.15.0

What happened?

I use https://github.com/golang-migrate/migrate to create database migrations and sqlc to compile query into go code.

Here is my folder structure:

- db
  - dbutils // the generated go code from sqlc
  - migrations  // migration files from golang-migrate
  - queries // sql query for sqlc to generate
- go.mod
- go.sum
- main.go
- sqlc.yaml

Currently there is only 1 migration file inside db/migrations and 1 sql file inside db/queries. When I run sqlc generate, it succeed without error. However the generated db/dbutils/db.go contains highlighted error: cannot use tx (variable of type *sql.Tx) as DBTX value in struct literal: wrong type for method ExecContext

Relevant log output

No response

Database schema

CREATE TABLE IF NOT EXISTS review (
  id SERIAL PRIMARY KEY,
  url varchar NOT NULL,
  title varchar(512) NOT NULL,
  difficulty varchar(10) NOT NULL,
  due_date timestamptz NOT NULL,
  notes text,
  active boolean DEFAULT true,
  date_created timestamptz DEFAULT CURRENT_TIMESTAMP,
  date_updated timestamptz DEFAULT CURRENT_TIMESTAMP
);

SQL queries

-- name: GetReview :one
SELECT * FROM review
WHERE id = $1 LIMIT 1;

-- name: ListReviews :many
SELECT * FROM review
ORDER BY due_date ASC;

-- name: CreateReview :one
INSERT INTO review (
  url, title, difficulty, due_date, notes
) VALUES (
  $1, $2, $3, $4, $5
)
RETURNING *;

-- name: DeleteReview :exec
DELETE FROM review
WHERE id = $1;

Configuration

version: "1"
packages:
  - path: "db/dbutils"
    name: "dbutils"
    engine: "postgresql"
    schema: "db/migrations"
    queries: "db/queries"
    emit_json_tags: true
    emit_prepared_queries: false
    emit_interface: false
    emit_exact_table_names: false

Playground URL

No response

What operating system are you using?

Linux

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[kyleconroy]

I can't reproduce this. What version of Go are you using?

[varian97]

@kyleconroy I use go 1.19

actually this is a bit weird, I try to follow the quick start project on https://docs.sqlc.dev/en/latest/tutorials/getting-started-postgresql.html and it works perfectly fine.

Maybe the issue come from my project setup itself, I will try to re-do the project setup and gives update as soon as possible

[varian97]

@kyleconroy after recreated the project, the error message is now gone and it is working perfectly now.
I don't know what the cause is, but I guess the issue is not coming from sqlc.

[Atixx]

For anyone coming to this issue and hoping for some sort of answer:

I've had a similar issue that ended up being a misconfigured sqlc.yaml I had the sql_package field set to "pgx/v4" but I was using the standard "database/sql" package. Even after changing the yaml you have to re-generate the queries, once I did both, it was working fine.

[rdforte]

For anyone else who might run into this issue and is using VSCode. I fixed this problem by upgrading my Go for Visual Studio Code extension to the latest version.