sqlc
sqlc copied to clipboard
sqlc-dev
Materialized Views don't support schema migrations
Version
1.12.0
What happened?
The following migrations result in sqlc believing the materialized view exists in the main public schema, when it has in fact moved
I am running sqlc off the main branch.
-- migration 1:
CREATE MATERIALIZED VIEW something AS
select * from events
where event_type = 'sale'
order by created_at desc;
-- migration 2:
create schema computed_tables;
alter materialized view "something" set schema "computed_tables";
-- query:
-- name: SomeQuery :many
select id from "computed_tables"."something";
Relevant log output
No response
Database schema
No response
SQL queries
No response
Configuration
No response
Playground URL
No response
What operating system are you using?
macOS
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
