Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [BUGS] Behavior change of FK info query
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: khanzahid235(at)yahoo(dot)com
- Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org
- Subject: Re: [BUGS] Behavior change of FK info query
- Date: Tue, 04 Nov 2008 08:22:15 -0500
- Message-id: <16205.1225804935@sss.pgh.pa.us> <text/plain>
Zahid Khan <khanzahid235(at)yahoo(dot)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 creating table even on psql.As psqlODBC drives executes query no 3 below to get foreign key information.if we want to reproduce this , 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
- Follow-Ups:
- Re: [BUGS] Behavior change of FK info query
- From: Hiroshi Saito
- Re: [BUGS] Behavior change of FK info query
- Prev by Date: Re: [GENERAL] Error in Adding All Tables
- Next by Date: Re: [BUGS] Behavior change of FK info query
- Previous by thread: Error in Adding All Tables
- Next by thread: Re: [BUGS] Behavior change of FK info query
- Indexes: