Skip to content

View on GTT not replicated in new sessions #60

@abb9979

Description

@abb9979

Views on top of temporary tables managed by pgtt are not replicated for new sessions.

Test case

Deployment session:

postgres=> load 'pgtt';
LOAD

postgres=> show search_path;
         search_path
------------------------------
 "$user", public, pgtt_schema

postgres=> CREATE /*GLOBAL*/ TEMPORARY TABLE gtt ( id int PRIMARY KEY, data text );
CREATE TABLE

postgres=> CREATE VIEW gtt_v AS SELECT * FROM gtt;
NOTICE:  view "gtt_v" will be a temporary view
CREATE VIEW

postgres=> SELECT * FROM gtt_v;
 id | data
----+------
(0 rows)

New user session:

postgres=> load 'pgtt';
LOAD

postgres=> show search_path;
         search_path
------------------------------
 "$user", public, pgtt_schema

postgres=> SELECT * FROM gtt_v;
ERROR:  relation "gtt_v" does not exist
LINE 1: SELECT * FROM gtt_v;
                      ^

postgres=> SELECT * FROM gtt;
 id | data
----+------
(0 rows)

Version info:

  • PostgreSQL 17.7
  • pgtt 4.4.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions