Skip to content

Rewrite sequence expressions in views #61205

@the-ericwang35

Description

@the-ericwang35

Describe the problem
After #59864, we're now rewriting DEFAULT expressions to reference sequences via their IDs. This results in the ability for sequences used in default expressions to be renamed. However, we don't perform this rewrite for views that reference sequences. As a result, we still cannot rename sequences used in views.

To Reproduce

CREATE SEQUENCE s;
CREATE VIEW v AS SELECT nextval('s');
ALTER SEQUENCE s RENAME TO s2;  // ERROR: cannot rename relation "s" because view "v" depends on it

Expected behavior
We should rewrite sequence expressions in views to also reference sequences by ID. This will allow us to rename sequences that are used in views.

Metadata

Metadata

Labels

C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions