BUG #16703: pg-dump fails to process recursive view definition
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #16703: pg-dump fails to process recursive view definition |
| Дата | |
| Msg-id | 16703-e348f58aab3cf6cc@postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #16703: pg-dump fails to process recursive view definition
|
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16703 Logged by: Alexander Lakhin Email address: exclusion@gmail.com PostgreSQL version: 13.0 Operating system: Ubuntu 20.04 Description: The following recursive views (borrowed from regress/sql/lock.sql, see "detecting infinite recursions in view definitions"): CREATE VIEW lock_view2(a) AS SELECT NULL::integer; CREATE VIEW lock_view3 AS SELECT * from lock_view2; CREATE OR REPLACE VIEW lock_view2 AS SELECT * from lock_view3; can be created successfully, but make a subsequent pg_dump fail: pg_dump: error: query failed: ERROR: infinite recursion detected in rules for relation "lock_view2" pg_dump: error: query was: LOCK TABLE public.lock_view2 IN ACCESS SHARE MODE The offending commit is 64fc3e03. Thanks to Andrew Bille for discovering this.
В списке pgsql-bugs по дате отправления: