Re: [INTERFACES] pgaccess 0.86 - wrong field sizes

Поиск
Список
Период
Сортировка
От Constantin Teodorescu
Тема Re: [INTERFACES] pgaccess 0.86 - wrong field sizes
Дата
Msg-id 35696171.2A8019FF@flex.ro
обсуждение исходный текст
Ответ на pgaccess 0.86  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
Список 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 по дате отправления:

Предыдущее
От: "Jose' Soares Da Silva"
Дата:
Сообщение: pgaccess 0.86
Следующее
От: David Hartwig
Дата:
Сообщение: Re: [SQL] ODBC Sources