Postgres Pro
Downloads
Home   >   mailing lists

Re: Nondestructive cluster, equivalent SQL? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Nondestructive cluster, equivalent SQL?
Date
Msg-id 22243.1022283949@sss.pgh.pa.us
Whole thread Raw
In response to Re: Nondestructive cluster, equivalent SQL?  ("Joshua b. Jore" <josh@greentechnologist.org>)
List pgsql-novice
Tree view 
"Joshua b. Jore" <josh@greentechnologist.org> writes:
> The sql-truncate.html documentation page doesn't say that truncate isn't
> transaction safe.

?  I see

: TRUNCATE cannot be executed inside a transaction block (BEGIN/COMMIT
: pair), because there is no way to roll it back.

This could perhaps be more verbose, but the point is covered...

            regards, tom lane

pgsql-novice by date:

Previous
From: "Joshua b. Jore"
Date:
Subject: Re: Nondestructive cluster, equivalent SQL?
Next
From: Andrew McMillan
Date:
Subject: Re: Why sequential scan when there's a supporting index?