| From: | joe(at)tanga(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key |
| Date: | 2012-06-19 19:49:20 |
| Message-ID: | E1Sh4QS-0000EB-4R@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryan Kelly | 2012-06-19 20:20:58 | Re: BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key |
| Previous Message | Heikki Linnakangas | 2012-06-19 12:39:03 | Re: BUG #6698: sub-query with join producing out of memory in where clause |