Re: sqlDescribeCol not setting null flag correctly for sqlDescribeCol

the6campbells wrote:
>
> A basic table is described where one column has a null
> constraint: create table TNUM( RNUM integer not null, CNUM numeric(7,2) )
> A simple view is defined that projects all the columns of said
> table: create view VNUM as select * from TNUM
> A query which projects the columns of the table or the view will return
> inconsistent null flags when you call sqlDescribeCol after sqlPrepare
>
> Does not matter if you have parse, server side prepare etc
> enabled/disabled.
>
> Looks like another bug to me.

It seems very hard for the driver to get more accurate results
than psql does. I see the following result via psql.

xxxxx=> \d tnum
Table "public.tnum"
Column | Type | Modifiers
--------+--------------+-----------
rnum | integer | not null
cnum | numeric(7,2) |

xxxxx=> \d vnum
View "public.vnum"
Column | Type | Modifiers
--------+--------------+-----------
rnum | integer |
cnum | numeric(7,2) |
View definition:
SELECT tnum.rnum, tnum.cnum
FROM tnum;

regards,
Hiroshi Inoue