| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: COPY example for partial tables |
| Date: | 2005-10-12 14:55:17 |
| Message-ID: | 200510121455.j9CEtHt10423@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
David Fetter wrote:
> 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.
I have attached and applied a modified version of this patch. I removed
the VACUUM (because this is just an example and does not need to be a
complete solution, e.g. pg_class bloat), and removed the 8.2 mention
because it seemed unnecessary.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 924 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Williams | 2005-10-13 01:12:34 | Update timestamp on update |
| Previous Message | Michael Fuhr | 2005-10-12 05:17:09 | Re: Commented, loadable databases as examples? |