From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | "Rhys A(dot)D(dot) Stewart" <rhys(dot)stewart(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: versioned pl/pgsql functions |
Date: | 2010-09-21 20:59:35 |
Message-ID: | 1285102775.15919.86.camel@jd-desktop.unknown.charter.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 the function could be versioned so that you could
> revert/rollback to a specific version of the function a la
> git/svn...and then you could do diffs and what not so that you
> wouldn't have to rely on text files which get lost because they were
> on a tiny jump drive.....
>
Hmmm, it seems this could be done relatively simply with the ability to
put triggers on system catalogs. The tablelog contrib function would
allow us to do this.
> Just my $1.70
>
>
>
> Regards,
>
> Rhys
>
> Peace & Love|Live Long & Prosper
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Caduto | 2010-09-21 21:04:52 | 9.0 pg_database datconfig ? |
Previous Message | Tomas Vondra | 2010-09-21 20:38:24 | Re: pg_relation_size / could not open relation with OID # |