On 07/22/2015 08:42 AM, Geoff Winkless wrote:
On 22 July 2015 at 16:32, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx
<mailto:jd@xxxxxxxxxxxxxxxxx>>wrote:
This is actually wrong. The end result is the same but it does not
in any way have the same effect.
"in any way"?
I'd say in the primary way it has the same effect: all rows are removed
from the table.
Thus the end result is the same as I said but the in practice effect is
quite different from a visibility, maintenance and programmability
perspective.
TRUNCATE is NOT DELETE.
I don't think anyone is suggesting that it is.
Except Tim Smith who started this thread.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
