Re: BUG #13776: Views with nested composite attributes can break pg_dump

From: Joshua Yanovski <pythonesque(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13776: Views with nested composite attributes can break pg_dump
Date: 2015-11-15 19:57:43
Message-ID: CABz-M-FH-pR4J3_mKVPeF+HaWycKELzE1-ijd97_95HXUZPhjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I actually found another place that it also affects (RowCompareExpr)
but that should be a two-line fix with the new function.

On Sun, Nov 15, 2015 at 11:42 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> pythonesque(at)gmail(dot)com writes:
>> # CREATE TABLE foo ();
>> # CREATE TYPE bar AS (x foo);
>> # CREATE VIEW baz AS SELECT ROW(foo)::bar FROM foo;
>> # \d+ baz
>> View definition:
>> SELECT ROW(foo.*)::bar AS "row"
>> FROM foo;
>
> Fixed, thanks for the report!
>
> regards, tom lane

--
Josh

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message 张文升 2015-11-16 02:37:09 Re: [BUGS] postgresql downgrade issue
Previous Message Tom Lane 2015-11-15 19:42:33 Re: BUG #13776: Views with nested composite attributes can break pg_dump