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