Re: version controlling postgresql code

akp geek  asked:

>
>         Would like to know if any one of you have used CVS or some other version controlling tools to version the
postgrescode? Any recommendations? Appreciate your help 
>
>


I used CVS at previous jobs.

Currently the place I work uses git and a set of rules for programmers who create DDL changes, including rollback
options(such as renaming columns to dropme_xxx instead of simply dropping them outright in the first change set). 

The SQL files are checked in with a timestamp which controls the order of updates when we apply them to runtime.

I've had unpleasant experiences with commercial tools; CVS works well for simple environments and git can be used for
moretangled development work. 

HTH,

Greg Williamson