Re: [GENERAL] Triggers and locking

2010-09-21 Thread William Temperley
On 21 September 2010 18:39, Alban Hertroys wrote: > On 21 Sep 2010, at 16:13, William Temperley wrote: > >> Dear all, >> >> I have a single "source" table that is referenced by six >> specialization tables, which include: >> "journal_article" >> "report" >> 4 more >> >> e.g.: >> """ >> update

Re: [GENERAL] Triggers and locking

2010-09-21 Thread Alban Hertroys
On 21 Sep 2010, at 16:13, William Temperley wrote: > Dear all, > > I have a single "source" table that is referenced by six > specialization tables, which include: > "journal_article" > "report" > 4 more > > e.g.: > """ > update source set citation = get_report_citation( >(select source

[GENERAL] Triggers and locking

2010-09-21 Thread William Temperley
Dear all, I have a single "source" table that is referenced by six specialization tables, which include: "journal_article" "report" 4 more There is a "citation" column in the source, which is what will be displayed to users. This is generated by a trigger function on each specialization table