Search Postgresql Archives

Re: Foreign Key error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux