Re: Foreign Key error

On 6/13/07, Jasbinder Singh Bali <jsbali(at)gmail(dot)com> 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