Re: Triggers & BLOB's

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: kevin kempter <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Triggers & BLOB's
Date: 2008-09-12 21:07:17
Message-ID: 20080912210717.GP8854@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

kevin kempter wrote:
> Hi All;
>
> Can I put an update/insert/delete trigger on a BLOB (lo_* style) column,
> It looks like the trigger should actually live on the data column of the
> pg_largeobject table to be effective. Is this correct ?

You can't put a trigger in pg_largeobject. Of course, you can put a
trigger in the table that you're storing the OID's in.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vivek_Sharan 2008-09-15 11:33:10 Re: Heavy postgres process
Previous Message kevin kempter 2008-09-12 21:01:39 Triggers & BLOB's