On 8th of February, Tom Lane committed patch: Core support for "extensions", which are packages of SQL objects.   This patch adds the server infrastructure to support extensions. There is still one significant loose end, namely how to make it play nice with pg_upgrade, so ...

Absolutely great post about designing database schema to contain information about marriages and partnerships with emphasis on changes brought to us by modern day - gay marriages, non-trivial sex/gender identities and polygamy.