René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"xid type is interface when using pgx","articleBody":"### Version\n\n1.30.0\n\n### What happened?\n\nI have set. I have a column that is set to xid8 in my postgres table. My understanding is that based on this PR: https://github.com/sqlc-dev/sqlc/pull/2668/changes. XID should be of type Uint32 however I am generating the code and am getting `interface{}` as the output.\n```\n        sql_package: \"pgx/v5\"\n        sql_driver: \"github.com/jackc/pgx/v5\"\n```\n\ntable:\n```sql\nCREATE TABLE IF NOT EXISTS audit_context (\n    txid xid8 PRIMARY KEY,\n    audit_user TEXT,\n    request_id TEXT,\n    audit_reason TEXT,\n    cohort_id BIGINT,\n    created_at TIMESTAMPTZ DEFAULT now()\n);\n```\n\nfull config\n```\n# yaml-language-server: $schema=https://raw.githubusercontent.com/sqlc-dev/sqlc/main/internal/config/v_two.json\nversion: \"2\"\nsql:\n  - engine: \"postgresql\"\n    queries: \"queries\"\n    schema: \"pos-db/migrations\"\n    strict_function_checks: true\n    strict_order_by: true\n    gen:\n      go:\n        package: \"model\"\n        out: \".\"\n        sql_package: \"pgx/v5\"\n        sql_driver: \"github.com/jackc/pgx/v5\"\n        emit_empty_slices: true\n        query_parameter_limit: 0\n        emit_sql_as_comment: true\n        emit_interface: true\n        overrides:\n          # Numeric type overrides\n          - go_type: github.com/shopspring/decimal.Decimal\n            db_type: pg_catalog.numeric\n          - go_type: github.com/shopspring/decimal.NullDecimal\n            db_type: pg_catalog.numeric\n            nullable: true\n\n          # JSONB column-specific overrides (types from libs/jsontypes)\n          - column: \"job.metadata\"\n            go_type:\n              import: \"github.com/Transformity/zeus/libs/jsontypes\"\n              type: \"JobMetadata\"\n              pointer: true\n\n          - column: \"entity.deployment_configuration\"\n            go_type:\n              import: \"github.com/Transformity/zeus/libs/jsontypes\"\n              type: \"DeploymentConfiguration\"\n              pointer: true\n```\n          - column: \"job_event.metadata\"\n            go_type:\n              import: \"github.com/Transformity/zeus/libs/jsontypes\"\n              type: \"JobMetadata\"\n              pointer: true\n```\n\n### Relevant log output\n\n```shell\n\n```\n\n### Database schema\n\n```sql\n\n```\n\n### SQL queries\n\n```sql\n\n```\n\n### Configuration\n\n```yaml\n\n```\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\nLinux\n\n### What database engines are you using?\n\nPostgresql\n\n### What type of code are you generating?\n\n_No response_","author":{"url":"https://github.com/jay-babu","@type":"Person","name":"jay-babu"},"datePublished":"2026-02-07T14:38:41.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/4290/sqlc/issues/4290"}