From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
---|---|
To: | BGoebel <b(dot)goebel(at)prisma-computer(dot)de> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Issue with ALTER Table. |
Date: | 2013-03-22 10:03:33 |
Message-ID: | 514C2C75.20302@vmware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 20.03.2013 17:49, BGoebel wrote:
> 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.
Can you provide a self-contained test case? That seems like the exact
same thing reported by Jan-Peter Seifelt, in the first thread that you
linked to, and that one was fixed. I can't reproduce it here, either. I
tested the attached test case, but it correctly prints the new size
after ALTER.
- Heikki
Attachment | Content-Type | Size |
---|---|---|
alter-test.c | text/x-csrc | 1.4 KB |
common.h | text/x-chdr | 5.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2013-03-22 11:03:19 | Re: Can I have commit access, please? |
Previous Message | Heikki Linnakangas | 2013-03-21 16:42:24 | Re: SQLExecute returns 0 rows with BoolsAsChar=1 |