Excerpts from Ryan Kelly's message of mar jun 19 16:20:58 -0400 2012: > On Tue, Jun 19, 2012 at 07:49:20PM +0000, j...@tanga.com wrote:
> > 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. The reason this doesn't work is that the primary key is not defined until later in the restore process. I think the fix is to make the view dependant on the primary key in the dump file. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
