pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SQL 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>
  2005-04-20 03:37 ` Re: SQL code versioning (views, functions, etc) Ezequiel Tolnay <mail@etolnay.com.ar>
  2005-04-23 05:06 ` Re: SQL code versioning (views, functions, etc) Tom Lane <tgl@sss.pgh.pa.us>
  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:22 SQL code versioning (views, functions, etc) Ezequiel Tolnay <mail@etolnay.com.ar>
@ 2005-04-20 03:37 ` 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-20 03:22 SQL code versioning (views, functions, etc) Ezequiel Tolnay <mail@etolnay.com.ar>
@ 2005-04-23 05:06 ` Tom Lane <tgl@sss.pgh.pa.us>
  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