Summary table trigger example race condition

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Summary table trigger example race condition
Date: 2006-01-05 21:36:45
Message-ID: 20060105213645.GY43311@pervasive.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

http://www.postgresql.org/docs/current/static/plpgsql-trigger.html
example 36-4 has a race condition in the code that checks to see if a
row exists. It should use the code from example 36-1. This patch fixes
that. It also adds some commands to show what the summary table output
looks like. Unfortunately gamke html is bombing with some kind of
library error, so I can't verify that I didn't break the sgml.

BTW, should this have gone to -docs instead?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

Attachment Content-Type Size
patch text/plain 3.2 KB

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Mark Kirkwood 2006-01-06 01:00:34 Re: Summary table trigger example race condition
Previous Message Jim Nasby 2006-01-04 18:07:53 Re: CONSTRAINT syntax in ALTER TABLE

Browse pgsql-patches by date

  From Date Subject
Next Message Mark Kirkwood 2006-01-06 01:00:34 Re: Summary table trigger example race condition
Previous Message Neil Conway 2006-01-05 21:27:58 Re: [HACKERS] Inconsistent syntax in GRANT