Re: Stored procedure version control - Mailing list pgsql-general

From Mark Morgan Lloyd
Subject Re: Stored procedure version control
Date
Msg-id nl2pef$d30$1@pye-srv-01.telemetry.co.uk
Whole thread Raw
In response to Re: Stored procedure version control  (Neil Anderson <neil@postgrescompare.com>)
Responses Re: Stored procedure version control
List pgsql-general
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?
>>
>
> I can't comment from the POV of those who represent Postgres, but I used
> to work for a company who specialised in change management for database
> products, SQL Server and Oracle in particular. There are at least two
> approaches. The migrations approach and the state based approach.

[etc.] Thanks everybody, summary passed on.

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]


pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: How safe is pg_basebackup + continuous archiving?
Next
From: Alex Ignatov
Date:
Subject: Re: How safe is pg_basebackup + continuous archiving?