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?
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
In response to
pgsql-sql by date
|Next:||From: Dmitri Fuerle||Date: 2003-10-20 15:07:13|
|Subject: Re: Question regarding triggers|
|Previous:||From: Tom Lane||Date: 2003-10-20 13:48:52|
|Subject: Re: Question regarding triggers |