Skip to content

In the properties window of the materialized view parameter toast_tuple_target is not present #9626

@krzotr

Description

@krzotr

Describe the bug

After I put toast_tuple_target on the materialized view, I don't see toast_tuple_target in the properties window.

Image
ALTER TABLE test_mv SET (toast_tuple_target = 128);

To Reproduce

Steps to reproduce the behavior:

  1. Run SQL commands
CREATE TABLE test AS
	SELECT generate_series(1,1000) AS id, REPEAT('a', 8000) AS descr;

CREATE MATERIALIZED VIEW test_mv AS (
	SELECT * FROM test WHERE id > 5
);

ALTER TABLE test_mv SET (toast_tuple_target = 128);

REFRESH MATERIALIZED VIEW test_mv;
  1. Go to Materialized Views -> test_mv -> Right click -> Properties -> Definition tab
  2. I don't see the field toast_tuple_target in the definition tab
  3. I cannot modify toast_tuple_target in the definition tab

Expected behavior

I should see the toast_tuple_target field in the definition tab, and I should modify it.

Screenshots

Image

Desktop (please complete the following information):

  • OS: Windows 11 x64
  • pgAdmin 9.12
  • Mode: Desktop
  • Browser Google Chrome
  • Package type: pgadmin4-9.12-x64.exe
  • Postgresql 18.1

Additional context

psql / pg_dump shows everything fine

#psql test=# \d+ test_mv
                                   Materialized view "public.test_mv"
 Column |  Type   | Collation | Nullable | Default | Storage  | Compression | Stats target | Description
--------+---------+-----------+----------+---------+----------+-------------+--------------+-------------
 id     | integer |           |          |         | plain    |             |              |
 descr  | text    |           |          |         | extended |             |              |
View definition:
 SELECT id,
    descr
   FROM test
  WHERE id > 5;
Access method: heap
Options: toast_tuple_target=128


#pg_dump -Upostgres -t test_mv --schema-only test

CREATE MATERIALIZED VIEW public.test_mv
WITH (toast_tuple_target='128') AS
 SELECT id,
    descr
   FROM public.test
  WHERE (id > 5)
  WITH NO DATA;

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    Status

    No status

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions