Thread

1. before trigger problem

   Marie G. Tuite <marie.tuite@edisonaffiliates.com> — 2003-08-26T22:42:33Z

   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
   
   
   
   

2. Re: before trigger problem

   Tom Lane <tgl@sss.pgh.pa.us> — 2003-08-28T03:43:18Z

   "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
   
   

3. Re: before trigger problem

   Marie G. Tuite <marie.tuite@edisonaffiliates.com> — 2003-08-28T15:18:56Z

   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.
   
   			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)
   
   
   
   

4. Re: before trigger problem

   Robert Treat <xzilla@users.sourceforge.net> — 2003-08-29T14:23:36Z

   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