From: Julius Tuskenis <julius@nsoft.lt>
To: pgsql-admin@postgresql.org
Subject: Re: Strange deletion problem
Date: Tue, 30 Mar 2010 11:28:59 +0300
Message-ID: <4BB1B64B.3080109@nsoft.lt> (raw)
In-Reply-To: <D29C98141027402A85C7801C69954C11@squarepi.com>
References: <D29C98141027402A85C7801C69954C11@squarepi.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: julius@nsoft.lt
Subject: Re: Strange deletion problem
In-Reply-To: <4BB1B64B.3080109@nsoft.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox