Re: Behavior change of FK info query - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Behavior change of FK info query
Date
Msg-id 16205.1225804935@sss.pgh.pa.us
Whole thread Raw
In response to Behavior change of FK info query  (Zahid Khan <khanzahid235@yahoo.com>)
List pgsql-bugs
Zahid Khan <khanzahid235@yahoo.com> writes:
> In my application we are getting different results in 8.2� and 8.3 servers. if we execute the query no 3 below after
creatingtable even on psql.As psqlODBC drives executes query no 3 below to get foreign key information.if we want to
reproducethis , we can executes the following queries on psql in sequence we are getting different results in 8.2� and
8.3. 

8.3 does not store any foreign-key information in pg_trigger.tgargs
anymore.  If psqlODBC is depending on this query then that's a psqlODBC
bug.  It'd be better to look at pg_constraint.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Zahid Khan
Date:
Subject: Behavior change of FK info query
Next
From: Craig Ringer
Date:
Subject: Re: Behavior change of FK info query