Skip site navigation (1) Skip section navigation (2)

Re: problem delete record error:heap_mark4update

From: Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>
To: "Alam Surya" <alam_surya(at)telkom(dot)net>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: problem delete record error:heap_mark4update
Date: 2003-05-29 20:00:48
Message-ID: 200305291700.48798.franco@akyasociados.com.ar (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

pgsql-general by date

Next:From: Tom LaneDate: 2003-05-29 20:00:57
Subject: Re: How to deny user changing his own password?
Previous:From: Tom LaneDate: 2003-05-29 19:55:42
Subject: Re: postgresql 7.3.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group