Re: problem delete record error:heap_mark4update

The same happened to me a while ago, it was not a delete but an update.

Tom Lane posted something about this problem, the error appeared (as far as I can remember) when in the
same command a tuple got modified more than once (because of a join in a one to many relationed
table, for example).

Yours doesn't seem to be the case, but perhaps a trigger is trying to do an update or something.

Anyway, I remember Tom was working on it, I don't know if there is a patch already, but I solved the
problem rewriting the update query in a way that the same tupple didn't get parsed twice.

Hope it helps.

On Thursday 29 May 2003 16:16, you wrote:
> HeLLo frank...
>
> I have seen that problem, please cecked your table....maybe in your table
> any trigger...
>
> regards...
>
> Alam Surya
>
>
> I work using postgresql in cygwin version:
> PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927
> (prerelease)
>
>
> When delete a record I recive the message :
> heap_mark4update: (am)invalid tid
>
> the sql command is:
> e.g
> delete from irtab where id=29353
>
>
> What this the problem?
>
> Thanks
>
> Bye !!
> Frank Lupo (Wolf) !!
>
> /\_ _/\
> \ o o /
> --ooo-----ooo---
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster