Обсуждение: Triggers & BLOB's

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 ?

Thanks in advance...

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