Robert, I'd like to have a copy of your script if you're willing to share. We're currently working on schema control stuff, and your script may be useful. On Wed, Oct 24, 2007 at 11:23:39PM -0400, Robert Treat wrote: > On Wednesday 24 October 2007 15:11, Roberts, Jon wrote: > > Yeah. I think having to save the function to disk and then leave pgAdmin > > to execute subversion commands is going through hoops. > > > > Also, pgAdmin should be integrated so that you are notified if the function > > in the database is different from the last committed version. A visual > > diff should be there so you can see what the differences are. > > > > We have a script that runs nightly that dumps tables / functions to file, and > then checks it in automagically to svn, which sends an email of the diffs. > Perhaps that would work for you? > > -- > Robert Treat > Database Architect > http://www.omniti.com > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Tim Goodaire 416-673-4126 tgoodair@xxxxxxxxxxxxxxx Database Team Lead, Afilias Canada Corp. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
