sqlc-dev · kyleconroy · Oct 13, 2023 · Oct 13, 2023 · Oct 13, 2023 · Oct 13, 2023
diff --git a/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/issue.md b/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/issue.md
@@ -0,0 +1 @@
+https://github.com/sqlc-dev/sqlc/issues/1519
diff --git a/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/go/db.go b/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/go/db.go
diff --git a/...nal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/go/models.go b/...nal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/go/models.go
diff --git a/.../endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/go/query.sql.go b/.../endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/go/query.sql.go
diff --git a/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/query.sql b/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/query.sql
@@ -0,0 +1,2 @@
+-- name: SomeQuery :many
+select id from "computed_tables"."something";
diff --git a/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/schema.sql b/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/schema.sql
@@ -0,0 +1,13 @@
+create table events (
+  id int,
+  event_type text not null,
+  created_at timestamptz
+);
+
+CREATE MATERIALIZED VIEW something AS
+select * from events
+where event_type = 'sale'
+order by created_at desc;
+
+create schema computed_tables;
+alter materialized view something set schema computed_tables;
diff --git a/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/sqlc.yaml b/internal/endtoend/testdata/ddl_alter_materialized_views_set_schema/postgresql/pgx/sqlc.yaml
@@ -0,0 +1,10 @@
+version: "2"
+sql:
+  - engine: "postgresql"
+    schema: "schema.sql"
+    queries: "query.sql"
+    gen:
+      go:
+        package: "querytest"
+        out: "go"
+        sql_package: "pgx/v5"
diff --git a/internal/engine/postgresql/parse.go b/internal/engine/postgresql/parse.go
@@ -236,7 +236,7 @@ func translate(node *nodes.Node) (ast.Node, error) {
 		n := inner.AlterObjectSchemaStmt
 		switch n.ObjectType {
 
-		case nodes.ObjectType_OBJECT_TABLE:
+		case nodes.ObjectType_OBJECT_TABLE, nodes.ObjectType_OBJECT_VIEW, nodes.ObjectType_OBJECT_MATVIEW:
 			rel := parseRelationFromRangeVar(n.Relation)
 			return &ast.AlterTableSetSchemaStmt{
 				Table:     rel.TableName(),
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- name: SomeQuery :many
		select id from "computed_tables"."something";