On Mon, May 23, 2005 at 05:06:18PM -0400, Sven Willenberger wrote:
> 
> I guess my question is, when only one of the fields of the primary key
> is used as a condition for a delete statement, is there a way to have
> slony issue just that simple command rather than expand the statement to
> include all the columns of the primary key?

No.  What you seem to want is SQL capture-and-ship.  pgpool does
something like that.  The only thing you're paying extra for is the
network, note: your single-condition DELETE really is touching every
row, and all of those statements will go to the replica at once,
because they're part of a single write set (having all occurred in
the same transaction).

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