Re: [BUGS] BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

2012-06-20 Thread Tom Lane
I wrote: We could possibly hack something for the special case of rules, but I don't think this would be the last time we hear about this type of issue. I'm inclined to think that the best solution would be to add generic logic to pg_dump that looks through any dependency references to

Re: [BUGS] BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

2012-06-20 Thread Tom Lane
I wrote: We could possibly hack something for the special case of rules, but I don't think this would be the last time we hear about this type of issue. BTW, after comparing the dependencies emitted by this patch to those of HEAD for the regression database, I am convinced that indeed view

[BUGS] BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

2012-06-19 Thread joe
The following bug has been logged on the website: Bug reference: 6699 Logged by: Joe Van Dyk Email address: j...@tanga.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

Re: [BUGS] BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

2012-06-19 Thread Ryan Kelly
On Tue, Jun 19, 2012 at 07:49:20PM +, j...@tanga.com wrote: The following bug has been logged on the website: Bug reference: 6699 Logged by: Joe Van Dyk Email address: j...@tanga.com PostgreSQL version: 9.1.4 Operating system: OSX Description: $

Re: [BUGS] BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

2012-06-19 Thread Alvaro Herrera
Excerpts from Ryan Kelly's message of mar jun 19 16:20:58 -0400 2012: On Tue, Jun 19, 2012 at 07:49:20PM +, 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

Re: [BUGS] BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

2012-06-19 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from Ryan Kelly's message of mar jun 19 16:20:58 -0400 2012: On Tue, Jun 19, 2012 at 07:49:20PM +, j...@tanga.com wrote: SELECT channels.id, channels.start_at, channels.end_at, channels.title FROM channels LEFT JOIN

Re: [BUGS] BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

2012-06-19 Thread Tom Lane
I wrote: We could possibly hack something for the special case of rules, but I don't think this would be the last time we hear about this type of issue. I'm inclined to think that the best solution would be to add generic logic to pg_dump that looks through any dependency references to

Re: [BUGS] BUG #6699: pg_restore with -j -- doesn't restore view that groups by primary key

2012-06-19 Thread Tom Lane
I wrote: 168; 1259 41968 TABLE public t1 postgres ; depends on: 5 1921; 2606 41975 CONSTRAINT public t1_pkey postgres ; depends on: 168 168 169; 1259 41976 VIEW public v1 postgres ; depends on: 1919 5 1922; 0 41968 TABLE DATA public t1 postgres ; depends on: 168