| From: | "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com> |
|---|---|
| To: | Divya Ramgopal <divyaramgopal(at)yahoo(dot)co(dot)in> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: TRIGGERS |
| Date: | 2003-05-05 11:39:30 |
| Message-ID: | Pine.LNX.4.44.0305051706520.2890-100000@Bhuvan.bksys.co.in |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> .So i tried Inserting a value into this column....However it gave me the
> error: "record new has no field lob" ...Is it because I have created a
> trigger on this table??
Yes.
> But will a trigger affect the whole table or just that particular column
> on which I have created the trigger for?? I'm a lil' confused and unable
> to find much thru' Google too....
Follow the below link to learn about triggered procedures:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=plpgsql-trigger.html
Still if you face problems, forward your table design and function code.
regards,
bhuvaneswaran
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-05-05 14:07:33 | Re: Application Development with PostgreSQL |
| Previous Message | Divya Ramgopal | 2003-05-05 10:54:10 | TRIGGERS |