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. Regards, ----------------------------------- Giampaolo Tomassoni - IT Consultant Piazza VIII Aprile 1948, 4 I-53044 Chiusi (SI) - Italy Ph: +39-0578-21100 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq