BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key
От | joe@tanga.com |
---|---|
Тема | BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key |
Дата | |
Msg-id | E1Sh4QS-0000EB-4R@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #6699: pg_restore with -j -- doesn't restore view
that groups by primary key
|
Список | pgsql-bugs |
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:=20=20=20=20=20=20=20=20 $ pg_restore -O -j 4 ~/tanga.dump -d tanga_dev_full_backup=20 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 =3D channels.id LEFT JOIN buyable_products bp ON bp.id =3D cp.product_id GROUP BY channels.id; channels.id is a primary key.
В списке pgsql-bugs по дате отправления: