Обсуждение: 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 />
<br /><br /><div class="gmail_quote">---------- Пересланное сообщение ----------<br />От: <b class="gmail_sendername">ЦелуйкоДмитрий</b> <span dir="ltr"><<a href="mailto:cdsmika@gmail.com">cdsmika@gmail.com</a>></span><br/> Дата: 21 мая 2009 г. 11:52<br />Тема: DDL triggers<br/>Кому: <a href="mailto:pgsql-bugs@postgresql.org">pgsql-bugs@postgresql.org</a><br /><br /><br />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 collect metadataabout structure (and it's modifications) of the database in my work.<br /><br />When DDL triggers will be supportedby PostgreSQL?<br /><br />In TODO PostgreSQL Wiki I've found only that:<br /><br />>Allow AFTER triggers on systemtables <dl><dd> >System tables are modified in many places in the backend without going through the executor andtherefore not causing triggers to fire. To complete this item, the >functions that modify system tables will have tofire triggers. </dl> Is it realization of DDL triggers or it will be a separate object?<br clear="all" /><br />-- <br />Суважением,<br /><font color="#888888">Дмитрий<br /></font></div><br /><br clear="all" /><br />-- <br />С уважением,<br/>Дмитрий<br />
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?