Re: Triggers & BLOB's - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Triggers & BLOB's
Date
Msg-id 20080912210717.GP8854@alvh.no-ip.org
Whole thread Raw
In response to Triggers & BLOB's  (kevin kempter <kevin@kevinkempterllc.com>)
List 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

pgsql-admin by date:

Previous
From: kevin kempter
Date:
Subject: Triggers & BLOB's
Next
From: "hanumantha reddy"
Date:
Subject: connecting to server