[DOCS] COPY example for partial tables

2005-10-11 Thread David Fetter
Folks, Please find enclosed a patch (should work for 7.3 and up) that illustrates a workaround for using COPY on parts of tables using temporary tables. It's helped me, and it seems popular via a very brief and un-scientific poll. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ p

Re: [DOCS] COPY example for partial tables

2005-10-11 Thread Jim C. Nasby
Why the vacuum? Seems a bit sever to do a vacuum of an entire database just because you created a temp table. On Tue, Oct 11, 2005 at 04:02:17PM -0700, David Fetter wrote: > Folks, > > Please find enclosed a patch (should work for 7.3 and up) that > illustrates a workaround for using COPY on part

Re: [DOCS] COPY example for partial tables

2005-10-11 Thread David Fetter
On Tue, Oct 11, 2005 at 06:12:53PM -0500, Jim C. Nasby wrote: > Why the vacuum? Seems a bit sever to do a vacuum of an entire database > just because you created a temp table. Excess enthusiasm about reclaiming space. It doesn't really need to be there :) Cheers, D > > On Tue, Oct 11, 2005 at 0

Re: [DOCS] COPY example for partial tables

2005-10-11 Thread Jim C. Nasby
On Tue, Oct 11, 2005 at 04:22:40PM -0700, David Fetter wrote: > On Tue, Oct 11, 2005 at 06:12:53PM -0500, Jim C. Nasby wrote: > > Why the vacuum? Seems a bit sever to do a vacuum of an entire database > > just because you created a temp table. > > Excess enthusiasm about reclaiming space. It does

Re: [DOCS] COPY example for partial tables

2005-10-11 Thread David Fetter
On Tue, Oct 11, 2005 at 06:33:42PM -0500, Jim C. Nasby wrote: > On Tue, Oct 11, 2005 at 04:22:40PM -0700, David Fetter wrote: > > On Tue, Oct 11, 2005 at 06:12:53PM -0500, Jim C. Nasby wrote: > > > Why the vacuum? Seems a bit sever to do a vacuum of an entire > > > database just because you created

[DOCS] Commented, loadable databases as examples?

2005-10-11 Thread Rich Morin
I would like to see some commented, loadable databases that folks can set up, play with, break, etc. They needn't be huge, just big enough to show off the feature(s) that are being demonstrated. I think this would be a good way to make the documentation a bit more concrete. -r -- email: [EMAIL

Re: [DOCS] Commented, loadable databases as examples?

2005-10-11 Thread Michael Fuhr
On Tue, Oct 11, 2005 at 09:57:33PM -0700, Rich Morin wrote: > I would like to see some commented, loadable databases that folks > can set up, play with, break, etc. They needn't be huge, just big > enough to show off the feature(s) that are being demonstrated. I > think this would be a good way t