Re: Re: [COMMITTERS] pgsql/src/backend/utils/adt (ri_triggers.c) - Mailing list pgsql-hackers

From Don Baccus
Subject Re: Re: [COMMITTERS] pgsql/src/backend/utils/adt (ri_triggers.c)
Date
Msg-id 3.0.1.32.20001120210926.021ecce0@mail.pacifier.com
Whole thread Raw
In response to Re: [COMMITTERS] pgsql/src/backend/utils/adt (ri_triggers.c)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
At 11:37 PM 11/20/00 -0500, Tom Lane wrote:
>inoue@postgresql.org writes:
>> Update of /home/projects/pgsql/cvsroot/pgsql/src/backend/utils/adt
>> Modified Files:
>>     ri_triggers.c 
>> keep relations open until they are no longer needed.
>
>Something that's been bothering me for a good while about ri_triggers
>is that it opens the relations without any lock to begin with.
>That can't possibly be safe, can it?

Hmmm...I only worked within the structure Jan built (to fix/implement
semantics) but there are efforts to lock things down with "select for
update" where Jan felt it was necessary.  Whether or not that's sufficient
is another question, but he obviously gave it *some* thought.



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Table/Column Constraints
Next
From: Don Baccus
Date:
Subject: Re: Re: [GENERAL] PHPBuilder article -- Postgres vs MySQL