| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | "Vasudevan, Ramya" <ramya(dot)vasudevan(at)classmates(dot)com>, hubert depesz lubaczewski <depesz(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: event triggers in 9.3.4 |
| Date: | 2014-07-27 05:15:42 |
| Message-ID: | CAFj8pRDt=Cj322EMpcF6t8YNfGU-_HnJ0sY0xr1B7-eYJoU0Nw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
2014-07-25 20:46 GMT+02:00 Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>:
> Pavel Stehule wrote:
> > Hello
> >
> > I found a interesting extension
> > http://code.malloclabs.com/pg_schema_triggers
>
> Ah, I remember that. I find that approach more cumbersome to use than
> mine. Note the ALTER cases can't tell you much about exactly how the
> relation has changed; you have to run comparisons of the pg_class rows
> manually, which is not very nice. I see this extension as a stopgap
> measure until we have real support for this in 9.5, per my patch.
>
I wish some similar interface for PL/pgSQL - json based interface is not
PL/pgSQL friendly. But it can live in contrib as extension over your
deparse interface - maybe as relatively simple SQL functions.
Regards
Pavel
>
> --
> Álvaro Herrera http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | klo uo | 2014-07-27 06:55:17 | Calltips in pgAdmin SQL Editor |
| Previous Message | Bruce Momjian | 2014-07-27 01:09:56 | Re: How to use pg_upgrade for beta versions |