这是indexloc提供的服务,不要输入任何密码
Skip to content

Add "Ignore tablespace" to Schema Diff #6004

@jflambert

Description

@jflambert

Describe the solution you'd like

In the "Compare" button dropdown (which has Ignore owner/whitespace) I would like to have a new "Ignore tablespace" option.

Some of my database tables have an explicit TABLESPACE pg_default; setting and some others don't have it declared at all. I'm not sure why. Of course, not declaring tablespace is equivalent to using pg_default. I'm using various docker flavours, some from timescaledb, some from debian, some on alpine. That must be why.

Describe alternatives you've considered

I'm not even sure I can redeclare tablespace post initdb. For now I just ignore these diffs, but I get a lot of false flags.

Additional context

Worth mentioning that even though there is a difference, the Difference panel doesn't show an instruction.

image

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions