On 6/13/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:
Hi,
I have a Pl/Perlu function in which I have written an insert statement in
tbl_xyz.
If there's not foreign key in this table, insert works fine.
As soon as i make one of its fields refer to tbl_abc i.e field a in tbl_xyz
refering to
field a in tbl_abc, insert fails.
Now the problem is, I can't see the actual error, i mean the place where it
fails.
Is there any way by which I can include a few lines of code that would log
any error in a file
whenever the insert fails.
Hmmm ... write debug output to a file in ~/tmp or
whatever as you would in any other perl program?
Syslog if you're tidy ;D
Thanks,
~Jas
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.
http://www.american.edu/econ/notes/htmlmail.htm
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
