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...
> 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
> When delete a record I recive the message :
> heap_mark4update: (am)invalid tid
> the sql command is:
> delete from irtab where id=29353
> What this the problem?
> Bye !!
> Frank Lupo (Wolf) !!
> /\_ _/\
> \ o o /
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2003-05-29 20:00:57|
|Subject: Re: How to deny user changing his own password? |
|Previous:||From: Tom Lane||Date: 2003-05-29 19:55:42|
|Subject: Re: postgresql 7.3.3 |