Issue with ALTER Table.

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.