You could setup a subversion commit hook to export the functions to the
database.
Then you adjust your development mentality to:
1) Edit the files on the disk
2) Commit to Subversion
Then the hook takes over and runs the drop/create automatically, you
could even have it email the developer if the create failed.
Roberts, Jon wrote:
> Robert, that does sound better. It keeps the names of the files in svn
> consistent with the database object names which is essential. It also makes
> it automatic. Unfortunately, it doesn't tell you who did the changes.
>
> Do you want to share that code?
>
>
> Thanks!
>
>
> Jon
>
> -----Original Message-----
> From: Robert Treat [mailto:robert@omniti.com]
> Sent: Wednesday, October 24, 2007 10:24 PM
> To: pgsql-general@postgresql.org
> Cc: Roberts, Jon
> Subject: Re: [GENERAL] subversion support?
>
> 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?
>
--
Brad Lhotsky <lhotskyb@mail.nih.gov>
NCTS Computer Specialist Phone: 410.558.8006
"Darkness is a state of mind, I can go where you would stumble."
-Wolfsheim, 'Blind'