Zeki Mokhtarzada <[EMAIL PROTECTED]> writes: > It appears that I can select the rows, but not delete or update them.
That's *very* odd, because it works for me. Is the same true of both those duplicate rows, or did you only try the one with nonzero xmax? I think there must be something we don't know about the states of those rows. Could you grab pg_filedump from http://sources.redhat.com/rhdb/ (note: right at the moment that server seems to be down, but I suppose it'll be up soon) and dump out page 53101 of this table? Usually I find "-i -f" to be the most informative formatting option. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster