[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] use of SQL command TRUNCATE
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] use of SQL command TRUNCATE |
Date: |
Mon, 27 Oct 2003 17:11:00 +0100 |
User-agent: |
Mutt/1.3.22.1i |
> If truncate doesn't work because of foreign key violation, delete won't either
true enough
> - unles youspecify a "cascade", in which case all referencing table rows will
> be deleted as well
down which road lies evil and misery from which I shall
restrain myself
must be the ordering of the truncate statements that's whacked ...
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346