Received: from flex.flex.ro (flex.flex.ro [193.230.255.2]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA17961; Mon, 25 May 1998 08:27:42 -0400 (EDT) Received: from flex.flex.ro (localhost [127.0.0.1]) by flex.flex.ro (8.8.8/8.7.3) with SMTP id PAA25588; Mon, 25 May 1998 15:17:53 +0300 Sender: teo@flex.flex.ro Message-ID: <35696171.2A8019FF@flex.ro> Date: Mon, 25 May 1998 15:17:53 +0300 From: Constantin Teodorescu Organization: FLEX Consulting Braila X-Mailer: Mozilla 3.04Gold (X11; I; Linux 2.0.33 i586) MIME-Version: 1.0 To: "Jose' Soares Da Silva" , PostgreSQL Interfaces CC: PostgreSQL Questions Subject: Re: [INTERFACES] pgaccess 0.86 - wrong field sizes References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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