> .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