Thread: Foreign Key error

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.

Thanks,
~Jas

On 6/13/07, Jasbinder Singh Bali <jsbali@gmail.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