Mike Sofen wrote:
-----Original Message-----
From: Mark Morgan Lloyd Sent: Thursday, June 30, 2016 2:41 AM
Neil Anderson wrote:
On 2016-06-29 12:37 PM, Mark Morgan Lloyd wrote:
Elsewhere, somebody was asking how people implemented version control
for stored procedures on (MS) SQL Server.
The consensus was that this is probably best managed by using scripts
or command files to generate stored procedures etc., but does anybody
have any comment on that from the POV of PostgreSQL?
[etc.] Thanks everybody, summary passed on.
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
A bit late to the thread, but here's some specific details on how I've
implemented version control in PG 9.5, in a small team environment deploying
to single database servers in each tier (dev, qa, stage, prod). It's
working well so far, and allows my stored proc versions to be aligned with
the middle and upper tier code releases. I'm the lead database
architect-engineer for a brand new genomics application (lots of data).
Thanks Mike, I'll pass that on if the thread on CIX still looks live.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
