Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Advice for generalizing trigger functions



--- 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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group