Oh, yeah. If you do manage to control schema drift by back porting, PostgreSQL will pick consistent names. But you can still trip over the inherent race conditi

Oh, yeah. If you do manage to control schema drift by back porting, PostgreSQL will pick consistent names. But you can still trip over the inherent race condition there if you don't specify names explicitly. We always considered automatic naming to be a shortcut, and used explicit names matching our internal naming conventions when creating and landing patches. I would snapshot the entire production schema every month or two with pg_dump and back port it into the dev tree, precisely to catch any unintended drift such as differences in naming, triggers, indexes etc. that fell between the cracks.