Foreign Key error

Поиск
Список
Период
Сортировка
От Jasbinder Singh Bali
Тема Foreign Key error
Дата
Msg-id a47902760706121249y787adcbai23bc7593d79dc3b1@mail.gmail.com
обсуждение исходный текст
Ответы Re: Foreign Key error
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: Database performance problem
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Database performance problem