Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group