X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 05F52D1D66C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  2 Feb 2004 18:44:14 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 28886-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  2 Feb 2004 14:44:06 -0400 (AST)
Received: from tht.net (vista.tht.net [216.126.88.2])
	by svr1.postgresql.org (Postfix) with ESMTP id C71BFD1D461
	for <pgsql-sql@postgresql.org>; Mon,  2 Feb 2004 14:43:58 -0400 (AST)
Received: from [134.22.69.227] (dyn-69-227.tor.dsl.tht.net [134.22.69.227])
	by tht.net (Postfix) with ESMTP
	id 0348D76A6D; Mon,  2 Feb 2004 13:44:01 -0500 (EST)
Subject: Re: Sometimes referential integrity seems not to work
From: Rod Taylor <pg@rbt.ca>
To: Jan Wieck <JanWieck@Yahoo.com>
Cc: Stephan Szabo <sszabo@megazone.bigpanda.com>,
 Tom Lane <tgl@sss.pgh.pa.us>,
	Enio Schutt Junior <enio@pmpf.rs.gov.br>, pgsql-sql@postgresql.org
In-Reply-To: <401E80D2.9080909@Yahoo.com>
References: <20040126175147.B3BD046E09@mail.passofundo.rs.gov.br>
	<20040131124500.H98710@megazone.bigpanda.com>
	<9148.1075592448@sss.pgh.pa.us>
	<20040131214655.W11452@megazone.bigpanda.com>
	<401E80D2.9080909@Yahoo.com>
Content-Type: text/plain
Message-Id: <1075747450.308.100.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Mon, 02 Feb 2004 13:44:10 -0500
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/21
X-Sequence-Number: 16712

> TRUNCATE cannot be used inside of a transaction, and since 7.3 it checks 
> for foreign keys. So I guess Enio is getting but ignoring the error 

In 7.4 truncate is transaction safe.