Re: BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

On Tue, Jun 19, 2012 at 07:49:20PM +0000, joe@tanga.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6699
> Logged by:          Joe Van Dyk
> Email address:      joe@tanga.com
> PostgreSQL version: 9.1.4
> Operating system:   OSX
> Description:
>
> $ pg_restore -O -j 4 ~/tanga.dump -d tanga_dev_full_backup
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 417; 1259 66296 VIEW
> site_channels monkey
> pg_restore: [archiver (db)] could not execute query: ERROR:  column
> "channels.start_at" must appear in the GROUP BY clause or be used in an
> aggregate function
> LINE 2:     SELECT channels.id, channels.start_at, channels.end_at, ...
>                                 ^
>     Command was: CREATE VIEW site_channels AS
>     SELECT channels.id, channels.start_at, channels.end_at, channels.title,
> channels.descriptio...
>
>
>
> site_channels view definition:
>
> View definition:
>  SELECT channels.id, channels.start_at, channels.end_at, channels.title
>    FROM channels
>    LEFT JOIN channels_products cp ON cp.channel_id = channels.id
>    LEFT JOIN buyable_products bp ON bp.id = cp.product_id
>   GROUP BY channels.id;
>
> channels.id is a primary key.

Attached is a test case to reproduce the problem, courtesy of the
original reporter.

>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

-Ryan