| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: about truncate |
| Date: | 2008-12-31 01:15:06 |
| Message-ID: | 20081231011506.GF12815@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Dec 30, 2008 at 04:07:33PM -0500, Jaime Casanova wrote:
> On Tue, Dec 30, 2008 at 2:00 PM, David Fetter <david(at)fetter(dot)org> wrote:
> > Here's one such use-case. Let's say a table has gotten large and
> > you've decided to partition it. You add child tables, add one or
> > more triggers to the parent table to make sure it never gets a
> > row, populate the child tables from the parent table, then you
> > want to remove all the rows from the parent table.
> >
>
> you're spying me?
D'oh! You've found out. Now that you know... ;)
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-12-31 02:38:24 | Re: TODO items for window functions |
| Previous Message | Kevin Grittner | 2008-12-31 00:33:26 | Re: incoherent view of serializable transactions |