Re: [GENERAL] Trouble with plpgsql generic trigger function using

2006-11-01 Thread Alban Hertroys
Lenorovitz, Joel wrote: I'd like to create a trigger function whose use can extend to multiple tables by employing the special variables available (e.g., TG_RELNAME). Below is a simple version of such a function that ought to prevent insertion of greater than 4 total records in the table that cal

Re: [GENERAL] Trouble with plpgsql generic trigger function using

2006-11-01 Thread Richard Huxton
Lenorovitz, Joel wrote: I'd like to create a trigger function whose use can extend to multiple tables by employing the special variables available (e.g., TG_RELNAME). [snip] Any advice on outputting the values of the variables to the console for inspection during testing would be welcome as wel

[GENERAL] Trouble with plpgsql generic trigger function using special variables

2006-10-31 Thread Lenorovitz, Joel
I'd like to create a trigger function whose use can extend to multiple tables by employing the special variables available (e.g., TG_RELNAME). Below is a simple version of such a function that ought to prevent insertion of greater than 4 total records in the table that calls it. I'm not sure that I