Mon Mar 13 03:44:38 PST 2006
- Previous message: [Slony1-general] large object support
- Next message: [Slony1-general] recommended version (postgres)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] large object support
- Next message: [Slony1-general] recommended version (postgres)
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list