Skip to content

View on GTT not replicated in new sessions #60

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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