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