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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
