-
Notifications
You must be signed in to change notification settings - Fork 15
Open
Description
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels