Re: Version/Change Management of functions?

On Friday 07 July 2006 13:08, Michael Loftis wrote:
> --On July 7, 2006 12:35:53 PM +0000 Roman Neuhauser <neuhauser(at)sigpipe(dot)cz>
>
> wrote:
> ># mloftis(at)wgops(dot)com / 2006-07-06 22:41:27 -0600:
> >> OK I know this is an odd question but I'm working on an app that will
> >> rely more and more on database driven functions, and while the app's
> >> source is in SVN, and I intend for the source of the SQL scripts to
> >> also be there, I was wondering...what are people doing for version
> >> control and change management on their custom (esp PL/pgSQL and say
> >> PL/Perl) functions?
> >
> > Well, "people" use a version control system.
> >
> > Do you have any specific questions?
>
> Yes, how exactly do you use it. Since there's no way to directly control
> whats in the DB via a VCS, further, how do you verify that what is in the
> DB is also in the VCS, etc? (I'm intentionally asking a bit of a 'dumb'
> question because I really want to find out exactly what others are doing).

I take text based schema dumps using the same file name each time and commit
them so that subversion can tell me the differences.

Joshua D. Drake

>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/