Обсуждение: DDL triggers

Поиск
Список
Период
Сортировка

DDL triggers

От
Целуйко Дмитрий
Дата:
Hi!<br /><br />Excuse me that I inquiring you by mail but I can't find answer on my questions.<br /><br />I need to
collectmetadata about structure (and it's modifications) of the database in my work.<br /><br />When DDL triggers will
besupported by PostgreSQL?<br /><br />In TODO PostgreSQL Wiki I've found only that:<br /><br />>Allow AFTER triggers
onsystem tables <dl><dd> >System tables are modified in many places in the backend without going through the
executorand therefore not causing triggers to fire. To complete this item, the >functions that modify system tables
willhave to fire triggers. </dl> Is it realization of DDL triggers or it will be a separate object?<br clear="all"
/><br/>-- <br />С уважением,<br />Дмитрий<br /> 

Fwd: DDL triggers

От
Целуйко Дмитрий
Дата:


---------- Пересланное сообщение ----------
От: Целуйко Дмитрий <cdsmika@gmail.com>
Дата: 21 мая 2009 г. 11:52
Тема: DDL triggers
Кому: pgsql-bugs@postgresql.org


Hi!

Excuse me that I inquiring you by mail but I can't find answer on my questions.

I need to collect metadata about structure (and it's modifications) of the database in my work.

When DDL triggers will be supported by PostgreSQL?

In TODO PostgreSQL Wiki I've found only that:

>Allow AFTER triggers on system tables
>System tables are modified in many places in the backend without going through the executor and therefore not causing triggers to fire. To complete this item, the >functions that modify system tables will have to fire triggers.
Is it realization of DDL triggers or it will be a separate object?

--
С уважением,
Дмитрий



--
С уважением,
Дмитрий

Re: DDL triggers

От
Peter Eisentraut
Дата:
On Thursday 21 May 2009 10:52:33 =D0=A6=D0=B5=D0=BB=D1=83=D0=B9=D0=BA=D0=BE=
 =D0=94=D0=BC=D0=B8=D1=82=D1=80=D0=B8=D0=B9 wrote:
> When DDL triggers will be supported by PostgreSQL?

There are currently no concrete plans for that, but if someone comes up wit=
h a=20
good design and implementation, it could be acceptable.  But don't hold you=
r=20
breath.

Re: DDL triggers

От
Christopher Browne
Дата:
In an attempt to throw the authorities off his trail, peter_e@gmx.net (Peter Eisentraut) transmitted:
> On Thursday 21 May 2009 10:52:33 Целуйко Дмитрий wrote:
>> When DDL triggers will be supported by PostgreSQL?
>
> There are currently no concrete plans for that, but if someone comes up with a
> good design and implementation, it could be acceptable.  But don't hold your
> breath.

An API that provides access to the ALTER statement would be a mighty
good thing.

I'd suppose that something like NEW_STATEMENT would be nice to have
access to.
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/internet.html
Why do they sterilize needles for lethal injections?