rename table and triggers

Started by Michele Petrazzo - Unipexalmost 16 years ago2 messagesgeneral
Jump to latest
#1Michele Petrazzo - Unipex
michele.petrazzo@unipex.it

Hi list,
now I just uncovered a strange behavior from my point of view: I have a
table with a trigger associated with its insert. If I rename that table,
the trigger "follow" its parent.
Are this a wanted and the normal behavior? Are there somewhere a
documentation about?

Thanks,
Michele

#2Vick Khera
vivek@khera.org
In reply to: Michele Petrazzo - Unipex (#1)
Re: rename table and triggers

On Fri, Jun 18, 2010 at 1:41 PM, Michele Petrazzo - Unipex
<michele.petrazzo@unipex.it> wrote:

now I just uncovered  a strange behavior from my point of view: I have a
table with a trigger associated with its insert. If I rename that table, the
trigger "follow" its parent.

The trigger is connected to the table, not the name of the table. It
doesn't care what the name is.