René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Materialized Views don't support schema migrations","articleBody":"### Version\r\n\r\n1.12.0\r\n\r\n### What happened?\r\n\r\nThe following migrations result in sqlc believing the materialized view exists in the main public schema, when it has in fact moved\r\n\r\nI am running sqlc off the main branch.\r\n\r\n```sql\r\n-- migration 1:\r\nCREATE MATERIALIZED VIEW something AS\r\nselect * from events\r\nwhere event_type = 'sale'\r\norder by created_at desc;\r\n\r\n\r\n-- migration 2:\r\ncreate schema computed_tables;\r\nalter materialized view \"something\" set schema \"computed_tables\";\r\n\r\n\r\n-- query:\r\n-- name: SomeQuery :many\r\nselect id from \"computed_tables\".\"something\";\r\n```\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/7475c4ff0c2d81393cd0baa57ede84f0fa0af5bd7ef4885f68450adde9f01b17\r\n\r\n### What operating system are you using?\r\n\r\nmacOS\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/malonehedges","@type":"Person","name":"malonehedges"},"datePublished":"2022-03-31T04:44:53.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/1519/sqlc/issues/1519"}