Re: event triggers in 9.3.4
| От | Pavel Stehule |
|---|---|
| Тема | Re: event triggers in 9.3.4 |
| Дата | |
| Msg-id | CAFj8pRDt=Cj322EMpcF6t8YNfGU-_HnJ0sY0xr1B7-eYJoU0Nw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: event triggers in 9.3.4 (Alvaro Herrera <alvherre@2ndquadrant.com>) |
| Список | pgsql-general |
Hello
2014-07-25 20:46 GMT+02:00 Alvaro Herrera <alvherre@2ndquadrant.com>:
Pavel Stehule wrote:Ah, I remember that. I find that approach more cumbersome to use than
> Hello
>
> I found a interesting extension
> http://code.malloclabs.com/pg_schema_triggers
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
В списке pgsql-general по дате отправления: