Re: [INTERFACES] pgaccess 0.86 - wrong field sizes

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>, PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Cc: PostgreSQL Questions <pgsql-questions(at)postgresql(dot)org>
Subject: Re: [INTERFACES] pgaccess 0.86 - wrong field sizes
Date: 1998-05-25 12:17:53
Message-ID: 35696171.2A8019FF@flex.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • pgaccess 0.86 at 1998-05-25 12:56:14 from Jose' Soares Da Silva

Browse pgsql-interfaces by date

  From Date Subject
Next Message Jose' Soares Da Silva 1998-05-25 12:56:14 pgaccess 0.86
Previous Message Herouth Maoz 1998-05-25 08:06:34 pgAccess - how does one set user?