Josh Berkus wrote:
> Dado,
>
> > But still, the $1 is still plaguing me.
> >
>
> Here's your problem:
>
> > >>CREATE FUNCTION new_proj_pts_seq(int4)
> > >>RETURNS text
> > >>AS 'DECLARE
> > >>proj_ID alias for $1;
> > >>seq_name TEXT;
> > >>BEGIN
> > >>seq_name := '
Dado,
> But still, the $1 is still plaguing me.
>
Here's your problem:
> >>CREATE FUNCTION new_proj_pts_seq(int4)
> >>RETURNS text
> >>AS 'DECLARE
> >>proj_ID alias for $1;
> >>seq_name TEXT;
> >>BEGIN
> >>seq_name := ''proj_pts_'' || proj_ID;
> >>create seq
Michael Davis wrote:
>
> Setting NEW in an AFTER update or insert trigger is not wise. Try using a before
>update trigger instead.
>
I still get the error message.
> -Original Message-
> From: Joseph Shraibman [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 6:35 PM
>
