Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 8C6766325D0
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 30 Mar 2010 05:29:27 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 44437-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 30 Mar 2010 08:29:16 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.csc.lt (mail.csc.lt [193.138.191.5])
	by mail.postgresql.org (Postfix) with ESMTP id 5FCD662DBD0
	for <pgsql-admin@postgresql.org>; Tue, 30 Mar 2010 05:29:15 -0300 (ADT)
Received: (qmail 15667 invoked by uid 210); 30 Mar 2010 08:29:12 -0000
Received: from mail.nsoft.lt by mail (envelope-from <julius@nsoft.lt>,
	uid 201) with qmail-scanner-2.05st
	(clamdscan: 0.95.3/10658. spamassassin: 3.2.1. perlscan: 2.05st.  
	Clear:RC:1(77.240.249.53):.
	Processed in 0.023221 secs); 30 Mar 2010 08:29:12 -0000
Received: from mail.nsoft.lt (77.240.249.53)
	by mail.csc.lt with SMTP; 30 Mar 2010 08:29:12 -0000
Received: from [192.168.16.103] (unknown [77.240.249.53])
	(using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.nsoft.lt (Postfix) with ESMTPS id 044C58E04F
	for <pgsql-admin@postgresql.org>; Tue, 30 Mar 2010 11:29:08 +0300 (EEST)
Message-ID: <4BB1B64B.3080109@nsoft.lt>
Date: Tue, 30 Mar 2010 11:28:59 +0300
From: Julius Tuskenis <julius@nsoft.lt>
Organization: UAB nSoft
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; lt;
	rv:1.9.1.8) Gecko/20100227 Lightning/1.0b1 Thunderbird/3.0.3
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Strange deletion problem
References: <D29C98141027402A85C7801C69954C11@squarepi.com>
In-Reply-To: <D29C98141027402A85C7801C69954C11@squarepi.com>
Content-Type: multipart/alternative;
	boundary="------------020201030100030601040108"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/236
X-Sequence-Number: 34035

This is a multi-part message in MIME format.
--------------020201030100030601040108
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

hello, John

2010.03.30 10:57, John Lister rašė:
> - Is there any other statements that could be causing the rows to be 
> removed that I've missed
Please see |TRUNCATE.|
> - Is there anything that could be deleting them without generating a 
> log entry for the statement?
Don't think so...
> - Is it possible that data corruption of either the index/table is 
> making my delete statements removed more rows?
Maybe you have foreign key with "On delete cascade" ?
> - Is it a possibly bug?
I don't know of such bug, but I'm no bug expert as well. I guess 
everything is possible.


-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050


--------------020201030100030601040108
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
hello, John<br>
<br>
2010.03.30 10:57, John Lister rašė:
<blockquote cite="mid:D29C98141027402A85C7801C69954C11@squarepi.com"
 type="cite">
  <div><font size="2" face="Arial">- Is there any other statements that
could be causing the rows to be removed that I've missed</font></div>
</blockquote>
Please see <code class="command">TRUNCATE.</code>
<blockquote cite="mid:D29C98141027402A85C7801C69954C11@squarepi.com"
 type="cite">
  <div><font size="2" face="Arial">- Is there anything that could be
deleting them without generating a log entry for the statement?</font></div>
</blockquote>
Don't think so...<br>
<blockquote cite="mid:D29C98141027402A85C7801C69954C11@squarepi.com"
 type="cite">
  <div><font size="2" face="Arial">- Is it possible that data
corruption of either the index/table is making my delete statements
removed more rows?</font></div>
</blockquote>
Maybe you have foreign key with "On delete cascade" ?<br>
<blockquote cite="mid:D29C98141027402A85C7801C69954C11@squarepi.com"
 type="cite">
  <div><font size="2" face="Arial">- Is it a possibly bug?</font></div>
</blockquote>
I don't know of such bug, but I'm no bug expert as well. I guess
everything is possible.<br>
<br>
<br>
<pre class="moz-signature" cols="72">-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050</pre>
</body>
</html>

--------------020201030100030601040108--