Re: refint doesn't work well with BDE

Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>

From: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
To: Jan Wieck <wieck@debis.com>
Cc: byron.nikolaidis@home.com, pgsql-interfaces@postgresql.org, ltibor@mail.tiszanet.hu
Date: 2000-04-05T15:17:46Z
Lists: pgsql-hackers
On Wed, 5 Apr 2000, Jan Wieck wrote:
>     First of all, 6.5.* didn't had the FOREIGN KEY implementation
>     your 7.0 message is coming from. It's completely new stuff.
Yes, you're right, sorry. I used the contrib/spi/refint* stuff in 6.5.2.

>     Second, since an ERROR is correctly reported (violating a  RI
>     constraint  is an ERROR and I cannot see any extra \n there),
>     the bug seems to be in the ODBC or BDE part, not  looking  at
>     the  return  code  but  trying to interpret the textual error
>     message.
Checking the ODBC source, I found two places in interfaces/odbc/info.c
with check_foreign_key and check_primary_key functions. They are the
names of the refint check functions in the "contrib" solution in 6.5.*
These places are queries which should be changed a bit, I think. Are these
changes enough to make it work, Byron?

Thank you again.

Regards, Zoltan