Обсуждение: 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 />
---------- Пересланное сообщение ----------
От: Целуйко Дмитрий <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
--
С уважением,
Дмитрий
От: Целуйко Дмитрий <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.
--
С уважением,
Дмитрий
--
С уважением,
Дмитрий
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.
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?