René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Renaming a materialized view causes `sqlc generate` to fail","articleBody":"### Version\n\n1.22.0\n\n### What happened?\n\nI have to update the query that backs a materialized view. \r\n\r\nTo do this, I create a new temporary materialized view, `view_2`, drop the old view, `view_1`, and rename the temporary view to the old view's name.\r\n\r\nI am renaming the temporary view using `alter materialized view view_2 rename to view_1`.\r\n\r\nWhen I run `sqlc generate`, SQLC states that the `view_1` does not exist, when in fact it does, it's just been renamed.\r\n\r\nFor context, I need to create a temporary materialized view, as dropping and recreating a materialized view will block all reads to the view. This is a two-step process, done in separate migrations. Postgres does not support updating a materialized view's query.\n\n### Relevant log output\n\n```shell\n# package db\r\nquery.sql:1:1: relation \"view_1\" does not exist\n```\n\n\n### Database schema\n\n```sql\ncreate materialized view view_1 as select x.* from (values(1), (1), (1)) as x;\r\n\r\ncreate materialized view view_2 as select x.* from (values(2), (2), (2)) as x;\r\n\r\ndrop materialized view view_1;\r\n\r\nalter materialized view view_2 rename to view_1;\n```\n\n\n### SQL queries\n\n```sql\n-- name: SelectView :many\r\nselect * from view_1;\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/f5ae38a7ec5718c27c64bbc03eccf3f118b68bfdf5d163a3f9caa4296cdfe5bb\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nPostgreSQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/JakeCapra","@type":"Person","name":"JakeCapra"},"datePublished":"2024-05-09T19:06:11.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/3371/sqlc/issues/3371"}