gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Gnumed-devel] objections to use of the postgres TRUNCATE command?


From: Busser, James
Subject: [Gnumed-devel] objections to use of the postgres TRUNCATE command?
Date: Sat, 29 Oct 2011 14:42:32 +0000

When taking a bootstrapped GNUmed database and wishing to clean out sample data 
in which the to-be-production site has no interest, TRUNCATE doubtless saves 
time. Provided that the tables have no foreign-key references from other 
tables, is there any reason (other than the inability to recover) NOT to use 
truncate in place of

        delete from

?

-- Jim


reply via email to

[Prev in Thread] Current Thread [Next in Thread]