René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc doesn't handle oid types correctly with pgx/v4","articleBody":"### Version\r\n\r\n1.20.0\r\n\r\n### What happened?\r\n\r\nFrom this discord thread: https://discord.com/channels/946447283321438248/1145749639916683305\r\n\r\nIt looks like sqlc-generated Go code tries to use a non-existent `pgtype.Uint32` for `cid` and `oid` database types when configured for `pgx/v4` which imports from `github.com/jackc/pgtype` (see https://github.com/sqlc-dev/sqlc/blob/v1.20.0/internal/codegen/golang/postgresql_type.go#L481).\r\n\r\nNote that with `pgx/v5` configured, sqlc imports from `github.com/jackc/pgx/v5/pgtype` which does appear to have the `pgtype.Uint32` type.\r\n\r\nSee the playground link for an example.\r\n\r\n### Relevant log output\r\n\r\n_No response_\r\n\r\n### Database schema\r\n\r\n_No response_\r\n\r\n### SQL queries\r\n\r\n_No response_\r\n\r\n### Configuration\r\n\r\n_No response_\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/e8c728dddddc0248aae7194bc4d0fac902cc43ae72c2d726a2d7f10c683f82e2\r\n\r\n### What operating system are you using?\r\n\r\n_No response_\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/andrewmbenton","@type":"Person","name":"andrewmbenton"},"datePublished":"2023-08-28T21:47:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2667/sqlc/issues/2667"}