pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSQL code versioning (views, functions, etc)
3+ messages / 2 participants
[nested] [flat]
* SQL code versioning (views, functions, etc)
@ 2005-04-20 03:22 Ezequiel Tolnay <mail@etolnay.com.ar>
0 siblings, 2 replies; 3+ messages in thread
From: Ezequiel Tolnay @ 2005-04-20 03:22 UTC (permalink / raw)
To: pgsql-admin
Hi all you pg gurus and admins,
I'm trying to implement versioning of the code of objects that can be
"created or replaced" (functions, views, etc).
I tried to implement a trigger on pg_proc, but that is not possible.
Adding a rule to the pg_proc table was successful but it never executes.
Is there a way or a tool to implement versioning of the code of this
objects? Help or hints will be gladly appreciated.
Cheers,
Ezequiel Tolnay
etolnay@gbtech.com.au
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SQL code versioning (views, functions, etc)
@ 2005-04-20 03:37 Ezequiel Tolnay <mail@etolnay.com.ar>
parent: Ezequiel Tolnay <mail@etolnay.com.ar>
1 sibling, 0 replies; 3+ messages in thread
From: Ezequiel Tolnay @ 2005-04-20 03:37 UTC (permalink / raw)
To: pgsql-admin
I just discovered that in the public schema (which I don't use) there is
a table pg_version_history. Does anyone know about this table?
It has versions of two test functions I seem to have created a couple of
months ago when I first installed postgresql, but I have no idea how
this table was created or what is its purpose, since although it seems
to be used to keep track of changes of function code (which is what I'm
looking for) it only has these two test functions, and I've created many
using different software.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SQL code versioning (views, functions, etc)
@ 2005-04-23 05:06 Tom Lane <tgl@sss.pgh.pa.us>
parent: Ezequiel Tolnay <mail@etolnay.com.ar>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2005-04-23 05:06 UTC (permalink / raw)
To: Ezequiel Tolnay <mail@etolnay.com.ar>; +Cc: pgsql-admin
Ezequiel Tolnay <mail@etolnay.com.ar> writes:
> I tried to implement a trigger on pg_proc, but that is not possible.
> Adding a rule to the pg_proc table was successful but it never executes.
Sorry, we don't support either rules or triggers on the system catalogs.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-04-23 05:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-20 03:22 SQL code versioning (views, functions, etc) Ezequiel Tolnay <mail@etolnay.com.ar>
2005-04-20 03:37 ` Ezequiel Tolnay <mail@etolnay.com.ar>
2005-04-23 05:06 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox