From: | "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com> |
---|---|
To: | "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Foreign Key error |
Date: | 2007-06-12 20:35:06 |
Message-ID: | b35603930706121335q1691e34el5de9a97244f6cbaa@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2007-06-12 20:35:25 | Re: Database performance problem |
Previous Message | Tom Lane | 2007-06-12 20:18:38 | Re: Date style handling changes between 7.4.12 and 8.2.4 |