Triggers

Started by itishree suklaalmost 13 years ago5 messagesgeneral
Jump to latest
#1itishree sukla
itishree.sukla@gmail.com

Hello Every one,

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

Regards,
Itishree

#2Jov
zhao6014@gmail.com
In reply to: itishree sukla (#1)
Re: Triggers

the later ,in same db

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

Show quoted text

Hello Every one,

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

Regards,
Itishree

#3itishree sukla
itishree.sukla@gmail.com
In reply to: Jov (#2)
Re: Triggers

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:

Show quoted text

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

#4Thomas Kellerer
spam_eater@gmx.net
In reply to: itishree sukla (#1)
Re: Triggers

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 logs in 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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#5Thomas Kellerer
spam_eater@gmx.net
In reply to: Thomas Kellerer (#4)
Re: Triggers

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"

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general