> For that matter - is there a reason it has to be an integer? Allowing > hostnames there would be more friendly. Using integers means someone has to > maintain a mapping on node IDs to hostnames in a separate place, and then > that leads to mistakes, like someone thinking the standby node (2) is the > master hostname :/ > > As a quick observation, the host name, by itself, doesn't seem to be a candidate key. It would probably have made sense to use a varchar instead of an integer but it seems people treat such a key type as forbidden.
David J. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
