Postgres Pro
Downloads
Home   >   mailing lists

Re: rename table and triggers - Mailing list pgsql-general

From Vick Khera
Subject Re: rename table and triggers
Date
Msg-id AANLkTil2x9GSZYRhFnOi8YyzRioNDy21zlWoK0IBkl4W@mail.gmail.com
Whole thread Raw
In response to rename table and triggers  (Michele Petrazzo - Unipex <michele.petrazzo@unipex.it>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unable to determine what has a particular OID
Next
From: David Fetter
Date:
Subject: Re: use window as field name in 8.4