LastInsertId is not supported by this driver

[davidolrik]

I'm trying to get use LastInsertId(), but for some odd reason it fails with "LastInsertId is not supported by this driver" and from other discussions here it should just work™.

I have tried to condense my problem down to a simple "connect & insert" with debug.

The generated query is INSERT INTO "test" ("id", "name") VALUES (DEFAULT, 'foo') RETURNING "id" but alas I still get "LastInsertId is not supported by this driver".

Is LastInsertId() not supported by the bun postgres driver, or am I doing something wrong?

import(
    "github.com/uptrace/bun"
    "github.com/uptrace/bun/dialect/pgdialect"
    "github.com/uptrace/bun/driver/pgdriver"
    "github.com/uptrace/bun/extra/bundebug"
)


type Test struct {
	bun.BaseModel `bun:"table:test"`

	ID   int64 `bun:"id,pk,autoincrement"`
	Name string
}

func main() {
    dsn := fmt.Sprintf(
        "postgres://%s:%s@%s:%d/%s?sslmode=%s",
        ...
    )
    sqldb := sql.OpenDB(pgdriver.NewConnector(pgdriver.WithDSN(dsn)))
    db := bun.NewDB(sqldb, pgdialect.New())
    db.AddQueryHook(bundebug.NewQueryHook(bundebug.WithVerbose(true)))

    t := &Test{}
    t.Name = "foo"

    r, err := db.NewInsert().
        Model(t).
        Exec(ctx)
        if err != nil {
            panic(err)
        }

        id, err := r.LastInsertId()
        if err != nil {
            panic(err)
        }
}