Re: [INTERFACES] pgaccess 0.86 - wrong field sizes - Mailing list pgsql-interfaces

From Constantin Teodorescu
Subject Re: [INTERFACES] pgaccess 0.86 - wrong field sizes
Date
Msg-id 35696171.2A8019FF@flex.ro
Whole thread Raw
In response to pgaccess 0.86  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
List pgsql-interfaces
Jose' Soares Da Silva wrote:
>
> pgaccess displays the wrong size for types varchar (see your phonebook
> example):
>
> table name      phonebook
> owner           marco
> field information:
> ---------------------------------------
> field name      field type      size
> ---------------------------------------
> name            varchar         -5           <-- (32)


Yes. I know!

There were some changes in system tables struct between 6.2.1 and 6.3
and PgAccess is reporting wrong the varchar field size.

Is there anyone who could send me the appropriate SQL  query that must
be used in order to determine the field name, types and sizes in 6.3.2
version?

I didn't found any time to hack a bit the new system table structures.

--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

pgsql-interfaces by date:

Previous
From: "Jose' Soares Da Silva"
Date:
Subject: pgaccess 0.86
Next
From: David Hartwig
Date:
Subject: Re: [SQL] ODBC Sources