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(at)tanga(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6699
> Logged by: Joe Van Dyk
> Email address: joe(at)tanga(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

-Ryan