Re: rename table and triggers

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: rename table and triggers
Date: 2010-06-18 20:19:47
Message-ID: AANLkTil2x9GSZYRhFnOi8YyzRioNDy21zlWoK0IBkl4W@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 18, 2010 at 1:41 PM, Michele Petrazzo - Unipex
<michele(dot)petrazzo(at)unipex(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2010-06-19 01:03:10 Re: use window as field name in 8.4
Previous Message Tom Lane 2010-06-18 19:20:41 Re: Unable to determine what has a particular OID