René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Postgres system columns not working","articleBody":"### Version\n\n1.27.0\n\n### What happened?\n\nsqlc currently errors out with column \"…\" does not exist when referencing a PostgreSQL [system column](https://www.postgresql.org/docs/current/ddl-system-columns.html) (tableoid, xmin, cmin, xmax, cmax or ctid) in an SQL query.\r\n\r\nThere was already a pull request that should fix this. And there are tests to make sure this is working. See here [1745](https://github.com/sqlc-dev/sqlc/issues/1745)\r\n\r\nIn this thread, there was a comment, that its not working with 1.25. Sadly its also not working with 1.27. And if you change the version to 1.23 in the playground, its also not working.\n\n### Relevant log output\n\n```shell\nquery.sql:2:8: column \"xmin\" does not exist\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  bio  text\r\n);\n```\n\n\n### SQL queries\n\n```sql\nSELECT xmin, cmin, xmax, cmax, ctid FROM authors;\n```\n\n\n### Configuration\n\n```yaml\n{\r\n  \"version\": \"2\",\r\n  \"sql\": [{\r\n    \"schema\": \"schema.sql\",\r\n    \"queries\": \"query.sql\",\r\n    \"engine\": \"postgresql\",\r\n    \"gen\": {\r\n      \"go\": {\r\n        \"out\": \"db\"\r\n      }\r\n    }\r\n  }]\r\n}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/db9040344439ff1fcf601ba3e93486fca3e1b2c0644fb46e4563bbf81c675116\n\n### What operating system are you using?\n\n_No response_\n\n### What database engines are you using?\n\n_No response_\n\n### What type of code are you generating?\n\n_No response_","author":{"url":"https://github.com/werjo-gridfuse","@type":"Person","name":"werjo-gridfuse"},"datePublished":"2024-12-12T15:38:29.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/3742/sqlc/issues/3742"}