Обсуждение: Help! What has changed in the internal structure of PostgreSQL?

Hi, I'm having some troubles using the driver ODBC! The problem is that a did some reports with Crystal Reports XI
andused 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_0101but 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!

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

  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
PostgreSQL8.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.
Imean, my tables have the same strucuture, my data is also the same, my reports is the same, the only thing that has
changedis 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@archonet.com]
Sent:    seg 20/06/2005 10:57
To:    Rodrigo Katsumoto Sakai
Cc:    pgsql-general@postgresql.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

Rodrigo Katsumoto Sakai wrote:
>
>   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)
> );
[snip]
 > 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.

There's nothing I know of should cause these problems. What do you mean
by "mapped correctly".
--
   Richard Huxton
   Archonet Ltd