On 8/19/2004 3:36 PM, Jeremiah Jahn wrote:

> If you could, wouldn't that fix the problem? So, would it be worthwhile
> to be able to put a trigger on at least the LO table, maybe even other
> system tables (for schema replication). I assume that it's a performance
> issue that has prevented this before.

No. The issue is that system catalog updates most of the time don't go 
through the executor, but call heap_insert(), heap_update and 
heap_delete() directly. The trigger mechanism is in the executor.


Jan

> 
> -jj-  
> 
> On Thu, 2004-08-19 at 13:29, Doug McNaught wrote:
>> Jeremiah Jahn <jeremiah at cs.earlham.edu> writes:
>> 
>> > So it's not possible to just trigger off of the pg_large_object table?
>> 
>> No, you can't put triggers on system tables.
>> 
>> -Doug


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #