On Fri, Mar 10, 2006 at 04:57:21PM -0600, David Durham wrote:
> Andrew Sullivan wrote:

> >No.  That's what the problem is: it can't, because the lo_ functions
> >use OIDs as keys, and no triggers would fire.
> 
> Actually, just to be sure, can a trigger on a (non-oid) column cause 
> replication of the large object (whose oid is in the row) and then 
> replication of the entire row?

No.  The way the lo_ stuff works, the function puts a reference to an
oid in the pg_largeobject table.  So the trigger would indeed fire,
but you still wouldn't get the large object copied, because you can't
put a trigger on pg_largeobject.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism. 
                --Brad Holland