Re: Copy/delete issue - Mailing list pgsql-general

From Dennis Brakhane
Subject Re: Copy/delete issue
Date
Msg-id 226a19190812210528s2526a9c1tf182d58d4f14ab16@mail.gmail.com
Whole thread Raw
In response to Copy/delete issue  (Herouth Maoz <herouth@unicell.co.il>)
List pgsql-general
(Sorry for the forward, I forgot to CC the list)

On Wed, Dec 17, 2008 at 9:38 AM, Herouth Maoz <herouth@unicell.co.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.

pgsql-general by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: Copy/delete issue
Next
From: Adrian Klaver
Date:
Subject: Re: Copy/delete issue