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: (view raw, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group