Re: [GENERAL] versioned pl/pgsql functions

2010-09-22 Thread Nagy Zoltan
hi, a few weeks ago i found a project aimed at providing version control for pq: http://www.pgcon.org/2009/schedule/events/158.en.html http://www.post-facto.org/ it worth to try it out, and use it ;) regards, kirk On 09/21/10 21:56, Rhys A.D. Stewart wrote: > hey all, > > I think versioned pl/[

Re: [GENERAL] versioned pl/pgsql functions

2010-09-22 Thread Vick Khera
On Tue, Sep 21, 2010 at 7:28 PM, Joshua J. Kugler wrote: > Keep version control in version control. Make creation/replacement of > stored procedures part of your deployment system. > +1 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: h

Re: [GENERAL] versioned pl/pgsql functions

2010-09-21 Thread Merlin Moncure
On Tue, Sep 21, 2010 at 5:12 PM, Pavel Stehule wrote: > 2010/9/21 Joshua D. Drake : >> On Tue, 2010-09-21 at 14:56 -0500, Rhys A.D. Stewart wrote: >>> hey all, >>> >>> I think versioned pl/[pgsql|python|perl|bash|java] functions would be >>> a great addition to 9.1. Imagine that instead of CREATE

Re: [GENERAL] versioned pl/pgsql functions

2010-09-21 Thread Joshua J. Kugler
On Tuesday 21 September 2010, Dmitriy Igrishin elucidated thus: > Hey all, > > After ten years with stored procedures I am thinking so this is not > > > too well technique. Much better is writing stored procedures to a > > file and using usual tools for file's versioning. We did some tools > > for

Re: [GENERAL] versioned pl/pgsql functions

2010-09-21 Thread Dmitriy Igrishin
Hey all, After ten years with stored procedures I am thinking so this is not > too well technique. Much better is writing stored procedures to a file > and using usual tools for file's versioning. We did some tools for > storing a versions inside database, but still we prefer a standard > develope

Re: [GENERAL] versioned pl/pgsql functions

2010-09-21 Thread Pavel Stehule
2010/9/21 Joshua D. Drake : > On Tue, 2010-09-21 at 14:56 -0500, Rhys A.D. Stewart wrote: >> hey all, >> >> I think versioned pl/[pgsql|python|perl|bash|java] functions would be >> a great addition to 9.1. Imagine that instead of CREATE OR REPLACE >> FUNCTION you could do CREATE AND VERSION FUNCTIO

Re: [GENERAL] versioned pl/pgsql functions

2010-09-21 Thread Joshua D. Drake
On Tue, 2010-09-21 at 14:56 -0500, Rhys A.D. Stewart wrote: > hey all, > > I think versioned pl/[pgsql|python|perl|bash|java] functions would be > a great addition to 9.1. Imagine that instead of CREATE OR REPLACE > FUNCTION you could do CREATE AND VERSION FUNCTION and then all > modifications to

[GENERAL] versioned pl/pgsql functions

2010-09-21 Thread Rhys A.D. Stewart
hey all, I think versioned pl/[pgsql|python|perl|bash|java] functions would be a great addition to 9.1. Imagine that instead of CREATE OR REPLACE FUNCTION you could do CREATE AND VERSION FUNCTION and then all modifications to the function could be versioned so that you could revert/rollback to a s