Re: BUG #13776: Views with nested composite attributes can break pg_dump - Mailing list pgsql-bugs

From Joshua Yanovski
Subject Re: BUG #13776: Views with nested composite attributes can break pg_dump
Date
Msg-id CABz-M-FH-pR4J3_mKVPeF+HaWycKELzE1-ijd97_95HXUZPhjA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #13776: Views with nested composite attributes can break pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@sss.pgh.pa.us> wrote:
> pythonesque@gmail.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13776: Views with nested composite attributes can break pg_dump
Next
From: Haribabu Kommi
Date:
Subject: Re: BUG #13741: vacuumdb does not accept valid password