before trigger problem

Started by Marie G. Tuiteover 22 years ago4 messages

marie.tuite@edisonaffiliates.com

over 22 years ago

I have a problem with a before trigger raising a heap_mark4update error. It
happens when there are many updates on the same key. OIDs are off
presumably? Am running 7.3.2 on RH 7.3. Have looked around the archives
and found nothing useful - a mention of a known issue and a potential patch?
Or suggestions that vacuum will sporadically clean it up.

I have hack in place - not a long term solution.

Thoughts? Suggestions?

Thanks.

-Marie

Tom Lane

tgl@sss.pgh.pa.us

over 22 years ago

In reply to: Marie G. Tuite (#1)

Re: before trigger problem

"Marie G. Tuite" <marie.tuite@edisonaffiliates.com> writes:

I have a problem with a before trigger raising a heap_mark4update error. It
happens when there are many updates on the same key. OIDs are off
presumably? Am running 7.3.2 on RH 7.3. Have looked around the archives
and found nothing useful - a mention of a known issue and a potential patch?

Is this the same issue described at
http://archives.postgresql.org/pgsql-hackers/2003-03/msg01099.php
? If so, update to 7.3.4.

regards, tom lane

Marie G. Tuite

marie.tuite@edisonaffiliates.com

over 22 years ago

In reply to: Tom Lane (#2)

Re: before trigger problem

Same issue - are there rpms anywhere for 7.3.4?

Thanks.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane
Sent: Wednesday, August 27, 2003 10:43 PM
To: marie.tuite@edisonaffiliates.com
Cc: Pgsql-General@Postgresql. Org; pgsql-hackers@postgresql.org
Subject: Re: [GENERAL] before trigger problem

"Marie G. Tuite" <marie.tuite@edisonaffiliates.com> writes:

I have a problem with a before trigger raising a heap_mark4update error.

happens when there are many updates on the same key. OIDs are off
presumably? Am running 7.3.2 on RH 7.3. Have looked around the archives
and found nothing useful - a mention of a known issue and a potential

patch?

Is this the same issue described at
http://archives.postgresql.org/pgsql-hackers/2003-03/msg01099.php
? If so, update to 7.3.4.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Robert Treat

xzilla@users.sourceforge.net

over 22 years ago

In reply to: Marie G. Tuite (#3)

Re: before trigger problem

http://developer.postgresql.org/ftpsite/binary/v7.3.4/RPMS/

Robert Treat

On Thu, 2003-08-28 at 11:18, Marie G. Tuite wrote:

Same issue - are there rpms anywhere for 7.3.4?

Thanks.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane
Sent: Wednesday, August 27, 2003 10:43 PM
To: marie.tuite@edisonaffiliates.com
Cc: Pgsql-General@Postgresql. Org; pgsql-hackers@postgresql.org
Subject: Re: [GENERAL] before trigger problem

"Marie G. Tuite" <marie.tuite@edisonaffiliates.com> writes:

I have a problem with a before trigger raising a heap_mark4update error.

It

happens when there are many updates on the same key. OIDs are off
presumably? Am running 7.3.2 on RH 7.3. Have looked around the archives
and found nothing useful - a mention of a known issue and a potential

patch?

Is this the same issue described at
http://archives.postgresql.org/pgsql-hackers/2003-03/msg01099.php
? If so, update to 7.3.4.

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL