PostgreSQL Newbies - Trigger Definition

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Trigger Definition

Prasad dev

2005-07-14, 8:24 pm

Hi all,

Just a quick question can we include two tables in the trigger definition ?

thanls
Prasad.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Michael Fuhr

2005-07-15, 3:24 am

On Thu, Jul 14, 2005 at 11:47:35PM +0000, Prasad dev wrote:
>
> Just a quick question can we include two tables in the trigger definition ?

CREATE TRIGGER takes a single table name. What are you trying to do?
Can you just create a trigger on each table, or is that not what you're
after?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links