Skip site navigation (1) Skip section navigation (2)

dumping recursive views broken in master

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: dumping recursive views broken in master
Date: 2012-10-12 18:00:40
Message-ID: 50785AC8.6080408@gmx.net (view raw or flat)
Thread:
Lists: pgsql-hackers
CREATE VIEW sums_1_100 AS
WITH RECURSIVE t(n) AS (
    VALUES (1)
UNION ALL
    SELECT n+1 FROM t WHERE n < 100
)
SELECT sum(n) FROM t;

dumps as

CREATE VIEW sums_1_100 AS
    WITH RECURSIVE t(n) AS (VALUES (1) UNION ALL SELECT (t_1.n + 1) FROM
t WHERE (t_1.n < 100)) SELECT sum(t.n) AS sum FROM t;

which doesn't load back, because of this missing FROM item "t_1".

Evidently, this is related to

commit 11e131854f8231a21613f834c40fe9d046926387
Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Date:   Fri Sep 21 19:03:10 2012 -0400

   Improve ruleutils.c's heuristics for dealing with rangetable aliases.


Responses

pgsql-hackers by date

Next:From: Abhijit Menon-SenDate: 2012-10-12 18:05:40
Subject: Re: [PATCH] explain tup_fetched/returned in monitoring-stats
Previous:From: Pavel StehuleDate: 2012-10-12 17:50:06
Subject: problem with mailing list

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group