From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: dumping recursive views broken in master |
Date: | 2012-10-12 18:48:46 |
Message-ID: | 17389.1350067726@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> 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.
Oops. I'll take a look.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2012-10-12 18:51:27 | Fix for log_line_prefix and session display |
Previous Message | Greg Stark | 2012-10-12 18:48:37 | Re: Deprecating RULES |