Re: Stored procedure version control

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]