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

Re: Re: more odbc patches

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Max Khon <fjoe(at)iclub(dot)nsu(dot)ru>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Re: more odbc patches
Date: 2001-01-23 04:45:45
Message-ID: 200101230445.XAA06897@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbcpgsql-patches
Can someone comment on this?

> 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
> 
> 


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-odbc by date

Next:From: Bruce MomjianDate: 2001-01-23 04:48:44
Subject: Re: subject_prefix not being set ...
Previous:From: The Hermit HackerDate: 2001-01-23 04:42:03
Subject: Re: subject_prefix not being set ...

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-01-23 04:53:09
Subject: Re: RE: SSL Connections [doc PATCH]
Previous:From: Tatsuo IshiiDate: 2001-01-23 01:04:12
Subject: Re: A Patch for MIC to EUC_TW code converting in mb support

pgsql-interfaces by date

Next:From: Bruce MomjianDate: 2001-01-23 04:47:40
Subject: Re: PL/Python (was: Re: [GENERAL] Re: Trigger)
Previous:From: Peter MountDate: 2001-01-22 22:04:07
Subject: Re: JDBC2 question -- can't find files needed

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