Postgres Pro
Downloads
Home   >   mailing lists

Thread: Triggers

Triggers

From
itishree sukla
Date:
Hello Every one,

Is Postgresql providing triggers on DB level, schema level ( in same DB)?


Regards,
Itishree

Re: Triggers

From
Jov
Date:

the later ，in same db

jov

在 2013-7-5 下午4:32，"itishree sukla" <itishree.sukla@gmail.com>写道：
Hello Every one,

Is Postgresql providing triggers on DB level, schema level ( in same DB)?


Regards,
Itishree

Re: Triggers

From
itishree sukla
Date:
I didn't get you, you mean  trigger is possible on schema level? if yes can you give example.

Thank you


On Fri, Jul 5, 2013 at 3:56 PM, Jov <zhao6014@gmail.com> wrote:

the later ，in same db

jov

在 2013-7-5 下午4:32，"itishree sukla" <itishree.sukla@gmail.com>写道：

Hello Every one,

Is Postgresql providing triggers on DB level, schema level ( in same DB)?


Regards,
Itishree

Re: Triggers

From
Thomas Kellerer
Date:
itishree sukla, 05.07.2013 10:29:
> Hello Every one,
>
> Is Postgresql providing triggers on DB level, schema level ( in same DB)?
>
You are probably referring to "DDL" triggers and similar things (a trigger when a table is created or dropped, a user
logsin and so on). 

The answer is no as far as I know.

Postgres 9.3 will add "event triggers", but they can only be written in SQL

Re: Triggers

From
Thomas Kellerer
Date:
Thomas Kellerer, 05.07.2013 13:46:
> Postgres 9.3 will add "event triggers", but they can only be written in SQL

That should have been: "only C and procedural languages like PL/pgSQL"