Re: Advice for generalizing trigger functions

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Erik Jones <erik(at)myemma(dot)com>
Cc: SQL Postgresql List <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Advice for generalizing trigger functions
Date: 2007-12-27 18:03:13
Message-ID: 276465.18598.qm@web31801.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--- On Thu, 12/27/07, Erik Jones <erik(at)myemma(dot)com> wrote:

> TG_TABLE_NAME will have the name of the table the trigger
> was fired on. With that and using EXECUTE for your INSERT
> statements, you'll probably be set.

True the table name is the easy part, but how do I determine the Primary Key components of the table that will also be needed in the SQL string that will be executed?

Regards,
Richard Broersma Jr.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Erik Jones 2007-12-27 18:22:33 Re: Advice for generalizing trigger functions
Previous Message Erik Jones 2007-12-27 17:51:59 Re: Advice for generalizing trigger functions