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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin