Re: Question regarding triggers

On Mon, 20 Oct 2003, A.Bhuvaneswaran wrote:

> > Why dont you try to write your trigger in C?
>
> Hi, one cannot write triggered procedures in C. Currently, it can only be
> written in plpsgql.

Where did you get that impression from?

Do an
SELECT tgrelid,tgfoid,proname from pg_trigger,pg_proc where
tgfoid=pg_proc.oid and prolang=13;
in your system to check if you have any :)

>
> > > CREATE FUNCTION "public"."check_shipment" () RETURNS trigger AS'
> > > begin
> > > If new.shipment_type_id = 4 then
> > > --do something
> > > end if;
> > > return new;
> > > end;
> > > in the above example everything works if shipment_type_id is being
> > > updated. If it is not I will receive a run-time error because
> > > shipment_type_id is not part of the record new.
>
> All the fields of updated record must available in NEW variable. Refer
> the manual for details. Forward your sql & run-time error for further
> assistance.
>
> regards,
> bhuvaneswaran
>
>

--
-Achilleus