Re: [BUGS] Behavior change of FK info query

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: [BUGS] Behavior change of FK info query

Hi.

> Zahid Khan writes:
>> In my application we are getting different results in 8.2=A0 and 8.3 s=
ervers. if we execute the=20
>> query no 3 below after creating table even on psql.As psqlODBC drives =
executes query no 3 below=20
>> to get foreign key information.if we want to reproduce this , we can e=
xecutes the following=20
>> queries on psql in sequence we are getting different results in 8.2=A0=
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.

Ahh, About foreign key, it will solve by 08.03.0300.
http://psqlodbc.projects.postgresql.org/release.html
I think that it is solvable by 4.).

It seems that I did what point of that mistake.

We has forgotten the information of a release.....sorry.
and, It seems that the test of UUID was not enough.
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/psqlodbc/psqlodb c/convert.c.d=
iff?r1=3D1.173&r2=3D1.174
One more condition fell out.
http://archives.postgresql.org/pgsql-odbc/2008-10/msg00010.p hp

Furthermore, I think it good to use libpq by which 8.3.5 was released.
So, it is better to pack up 08.03.0310.?

to Dave and Inoue-san.
What do you think?

Regards,
Hiroshi Saito


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc