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  (Ryan Kelly <rpkelly22@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Leif Halvorsen
Дата:
Сообщение: BUG #5823: launchd execution
Следующее
От: Ryan Kelly
Дата:
Сообщение: Re: BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key