Issue with ALTER Table.

Поиск
Список
Период
Сортировка
От BGoebel
Тема Issue with ALTER Table.
Дата
Msg-id 1363794560171-5749048.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Issue with ALTER Table.
Список pgsql-odbc
The Catalog Schema seems not to be actualized when using ALTER Table.

I had reported a problem with adding NEW tables, which was corrected by
Hiroshi

http://postgresql.1045698.n5.nabble.com/SQLDescribeCol-schema-cache-not-being-updated-completely-tt4372956.html

http://postgresql.1045698.n5.nabble.com/Error-Retrieving-Catalog-Info-tt4598955.html

When "altering" a Datatype of column the problem still exists:
Say, we have a column which is defined as varchar(40)
Now we want to double the field length to varchar(80)

  ALTER TABLE customer
     ALTER COLUMN address TYPE varchar(80),

When we retrieving the Catalog-Info the value of field length is 40
furthermore.

After a new connect we get the correct values and only after that writing /
reading to the altered field is working reliable.

Has someone found a another workaround, idea, hint preventing a reconnect?

regards,

BGoebel





--
View this message in context: http://postgresql.1045698.n5.nabble.com/Issue-with-ALTER-Table-tp5749048.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


В списке pgsql-odbc по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: SQLExecute returns 0 rows with BoolsAsChar=1
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: SQLExecute returns 0 rows with BoolsAsChar=1