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: 2001-01-23 09:12:34
Message-ID: Pine.BSF.4.21.0101231510580.12474-100000@iclub.nsu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-odbc pgsql-patches

hi, there!

On Mon, 22 Jan 2001, Bruce Momjian wrote:

> Can someone comment on this?

I have got more comments from Constantin: current implementation will fail
(return too many rows) if one table has two foreign keys, e.g.:
CREATE TABLE prim(i integer PRIMARY KEY);
CREATE TABLE f(i integer REFERENCES prim, j integer REFERENCES prim);

> > 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 Dave Page 2001-01-23 09:19:00 RE: Re: extremely newbie questions
Previous Message Max Khon 2001-01-23 08:41:29 RE: bug in ODBC driver (and fix)

Browse pgsql-odbc by date

  From Date Subject
Next Message Cedar Cox 2001-01-23 09:48:13 RE: Driver updates for 7.1
Previous Message Max Khon 2001-01-23 08:41:29 RE: bug in ODBC driver (and fix)

Browse pgsql-patches by date

  From Date Subject
Next Message Cedar Cox 2001-01-23 11:15:33 Re: Re: more odbc patches
Previous Message Ian Lance Taylor 2001-01-23 06:06:21 Support for cursors in PL/pgSQL