>> The MAC-based generator function could also be included in the backend, >> actually: it just needs to take an argument of type "macaddr". It would >> then be up to the user (and/or various pgfoundry and contrib/ modules) >> to find a way to determine the local machine's MAC address, which >> presumably can't be done reliably in a portable fashion. > > I assume we could just allow the MAC address or some unique idenfier to > be specified in postgesql.conf.
Well at that point why don't we allow it to be specified per database? ALTER DATABASE foo SET uuid_salt = :) That would be pretty cool, but I am sure most will shoot that down in flames :) Sincerely, Joshua D. Drake > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq