On Thu, Jun 07, 2007 at 02:46:02PM -0400, Bill Moran wrote:
> 
> I have a need to connect to a database, and quickly and easily determine
> whether it is the slony master or a slony slave.  Currently, I do a 

There's no way to check that, because it's not a meaningful question. 
If you want to know whether a given _table_ is a replica or not, you
can find that out by looking in the _slony schema.  Look for the
tab_set in _slony.sl_table for your table, then look in the sl_set
table for that set number, and look at the set_origin.  Finally,
select last_value from sl_local_node_id.  Note that this is a
sequence, so be careful with it!

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
Unfortunately reformatting the Internet is a little more painful 
than reformatting your hard drive when it gets out of whack.
		--Scott Morris