Re: Re: more odbc patches

From: Max Khon <fjoe(at)iclub(dot)nsu(dot)ru>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Re: more odbc patches
Date: 2000-12-16 09:10:04
Message-ID: Pine.BSF.4.21.0012161508060.31139-100000@iclub.nsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-odbc pgsql-patches

hi, there!

how about this?

--- cut here ---
>From cs(at)plesk(dot)com Sat Dec 16 15:08:40 2000
Date: Thu, 14 Dec 2000 17:00:43 +0600 (NOVT)
From: Constantin S. Svintsoff <cs(at)plesk(dot)com>
To: fjoe(at)iclub(dot)nsu(dot)ru
Subject: Bug in SQLForeignKeys()

Query used for checking foreign key triggers
returns too many results when there're more than one foreign
key in a table. It happens because only table's oid is used to
link between pg_trigger with INSERT check and pg_trigger with
UPDATE/DELETE check.

I think there should be enough to add following conditions
into WHERE clause of that query:
AND pt.tgconstrname = pg_trigger.tgconstrname
AND pt.tgconstrname = pg_trigger_1.tgconstrname

/Constantin
--- cut here ---

/fjoe

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ingo Luetkebohle 2000-12-16 14:06:57 updateable JDBC result sets?
Previous Message Emmanuel Charpentier,,, 2000-12-16 08:29:04 Coppatibility of ODBC drivers with forecoming 7.1

Browse pgsql-odbc by date

  From Date Subject
Next Message Katsuyuki Tanaka 2000-12-18 13:41:48 jdbc connectint ot db
Previous Message Bruce Momjian 2000-12-15 19:12:15 Re: Re: more odbc patches

Browse pgsql-patches by date

  From Date Subject
Next Message Michael Davis 2000-12-16 21:09:10 Bug fix
Previous Message Michael Davis 2000-12-16 00:05:48 Bug fix