[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: |
Sun, 26 Oct 2003 10:42:45 +0100 |
|
User-agent: |
Mutt/1.3.22.1i |
> Truncate doesn't appear to be allowed on tables that are referenced by
> another table.
> I am using Postgresql 7.3.3
Works on the older 7.1.x
> Why do we need it?
To clean out some tables before inserting data but an
unconditional delete will do, too, albeit slower.
Will change.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346