Re: pl/pgsql question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tim Perdue <tim(at)perdue(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pl/pgsql question
Date: 2002-12-18 04:26:18
Message-ID: 19736.1040185578@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tim Perdue <tim(at)perdue(dot)net> writes:
> I have created a function in pl/pgsql to modify a row before it gets put
^^^^^^^^^^^^^^^^^^^
> into the database, but it seems my modification is being ignored, and
> the unmodified row is being inserted.

> CREATE TRIGGER projtask_insert_depend_trig AFTER INSERT ON project_task
^^^^^^^^^^^^
> FOR EACH ROW EXECUTE PROCEDURE projtask_insert_depend();

I believe I see your problem ...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ludwig Lim 2002-12-18 04:29:33 Re: pl/pgsql question
Previous Message Tim Perdue 2002-12-18 04:12:27 pl/pgsql question