Re: Stored procedure version control

From: Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: Re: Stored procedure version control
Date: 2016-07-03 15:02:11
Message-ID: nlb9dk$6bf$1@pye-srv-01.telemetry.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

For completeness although this appears to be MS-specific, somebody has
drawn my attention to
http://www.red-gate.com/products/sql-development/sql-source-control/

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

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2016-07-03 15:06:55 9.3 to 9.5 upgrade problems
Previous Message trafdev 2016-07-03 04:01:29 Re: deadlock between "WITH agg_tmp AS ({sel_stmt}), upd AS ({upd_stmt}) {ins_stmt}" and pure UPDATE statements