Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbcpgsql-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

pgsql-odbc by date

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

pgsql-patches by date

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

pgsql-interfaces by date

Next:From: Dave PageDate: 2001-01-23 09:19:00
Subject: RE: Re: extremely newbie questions
Previous:From: Max KhonDate: 2001-01-23 08:41:29
Subject: RE: bug in ODBC driver (and fix)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group