> I assume by 'univocal' you mean unequivocal. Yes, sorry about that: I'm writing italish...
> Can you set it up in a table per server? or in a file? or would you > rather use a guuid? A per-server table will probably be my way. > And how is this to be made available? Well, a function would be fine. > And is it to be unique per machine, or per cluster (since you can have > many postgresql clusters on one machine). If it is a per-machine discriminator, it will be a per-node discriminator as well... Also, it will be useful to people not running a cluster (like me), since they only need a multi-master capability on a table for a legacy app... > cheers > > andrew Cheers, giampaolo > > Giampaolo Tomassoni wrote: > > >Dears, > > > >I'm looking for a way to univocally identify the server on which > a sql function or statement is running. My idea would be > something close to the value returned by a 'host -f' under linux: > the FQDN of the host, but even a serial code or a number would be > fine to me. It needs only to be immutable, I guess. > > > >I know there is something suitable under Oracle and, even worse, > under mysql... > > > >The purpose is mostly related to a light replication problem I > have, in which I need to 'emulate' a multi-master replication on a table. > > > >I placed a question on the IRC list and I found a couple of > unreplied messages asking the same thing in the pgsql-general list. > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend