[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] objections to use of the postgres TRUNCATE command?
|
From: |
Karsten Hilbert |
|
Subject: |
Re: [Gnumed-devel] objections to use of the postgres TRUNCATE command? |
|
Date: |
Mon, 31 Oct 2011 11:14:24 +0100 |
|
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Sat, Oct 29, 2011 at 02:42:32PM +0000, Jim Busser wrote:
> 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
Off-hand I wouldn't know of any reason.
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346