Re: Help! What has changed in the internal structure of PostgreSQL?

Well, the driver psqlodbc-07 works on PostgreSQL, but not very well!
My problem is that I have some tables, for exemple:

create table service (
cod_service int,
nam_service varchar(255) not null default '',
des_service varchar(255)
);

So I did some reports (Crystal Reports) on that table using PostgreSQL 7.4.x (linux )and after I migrate to PostgreSQL 8.0.3 (windowsXP). And I tried to use the same report to access the PostgreSQL 8, and then occured some errors, like the nam_service field couldn't be mapped correctly in the report, so I get blank reports without any data. I mean, my tables have the same strucuture, my data is also the same, my reports is the same, the only thing that has changed is the version of PostgreSQL, so I belive it has some mismatch with the internel structure or some error on the drivers.
So I need to know if the tables or views in the system catalogs have changed somehow!!??

Thanks!!

-----Original Message-----
From: Richard Huxton [mailto:dev(at)archonet(dot)com]
Sent: seg 20/06/2005 10:57
To: Rodrigo Katsumoto Sakai
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Help! What has changed in the internal structure of PostgreSQL?
Rodrigo Katsumoto Sakai wrote:
> Hi, I'm having some troubles using the driver ODBC! The problem is
> that a did some reports with Crystal Reports XI and used PostgreSQL
> 7.4.x with psqlodbc-07_03_0200, now I have migrate to PostgreSQL
> 8.0.3 and I'm using psqlodbc-08_00_0101 but the reports that I did is
> not working anymore because it is not mapping the fields of the
> tables correctly! I need to kwon what has changed in the structure
> (if changed) of the talbes! Thanks a lot!

What tables? What mapping? What is incorrect?

Also, have you ruled out some change in the ODBC driver? I believe
psqlodbc-07 should work with a version 8.0 PostgreSQL installation.

--
Richard Huxton
Archonet Ltd