Re: Copy/delete issue

From: "Dennis Brakhane" <brakhane+psql(at)googlemail(dot)com>
To: "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Copy/delete issue
Date: 2008-12-21 13:28:07
Message-ID: 226a19190812210528s2526a9c1tf182d58d4f14ab16@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

(Sorry for the forward, I forgot to CC the list)

On Wed, Dec 17, 2008 at 9:38 AM, Herouth Maoz <herouth(at)unicell(dot)co(dot)il> wrote:
> and for non-transaction tables (ones that have records that might
> change but don't accumulate based on time) it's DELETE without WHERE.

In that case, you are better off using TRUNCATE instead.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2008-12-21 18:28:48 Re: Copy/delete issue
Previous Message Herouth Maoz 2008-12-21 09:49:18 Re: Copy/delete issue