| From: | Julius Tuskenis <julius(at)nsoft(dot)lt> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Strange deletion problem |
| Date: | 2010-03-30 08:28:59 |
| Message-ID: | 4BB1B64B.3080109@nsoft.lt |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Williams | 2010-03-30 10:16:28 | Re: ERROR: could not open segment 1 of relation 1663/743352/743420 (target block 6407642): No such file or directory |
| Previous Message | Szymon Guz | 2010-03-30 08:24:07 | Re: Strange deletion problem |