Rebecca Clarke wrote on 07.06.2013 12:30:
I'm looking for suggestions on the best way to track the updates to a
function.
We have two databases, Dev & Live, so I want to update Live with just
the functions that have been modified in the DEV databas3e. Is there
another, easier way to track the updates than manually recording it
in a document? (I'm trying to eliminate human interference).
We are pretty happy using Liquibase for all our schema migrations.
For stored procedures/functions it's best to use a changeSet that includes a
SQL file
and is marked as runOnChange=true
The Liquibase changelog files are then stored in Subversion.
A little shell script applies the changes to any environment we want
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
