Re: finding schema of table that called a trigger

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jeff Hoffmann <jeff(at)propertykey(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: finding schema of table that called a trigger
Date: 2005-03-14 08:20:42
Message-ID: 4235495A.5020800@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jeff Hoffmann wrote:
> Is there a variable defined that has the schema of the table that called
> the trigger (like TG_RELNAME = table name)? I didn't see anything in
> the documentation. Is the only way to get that to look it up with
> TG_RELID?

I must admit I don't know of one. Hmm - it would obviously be simple
enough to add to the interface, but I presume there is some overhead for
each parameter you supply.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ragnar Hafstað 2005-03-14 08:46:33 Re: How to cast VARCHAR to BYTEA and vice-versa?
Previous Message Richard Huxton 2005-03-14 08:16:07 Re: sql: "LIKE" problem