M
mwalton@microstrategy.com
Guest
We have a customer asking that the Greenplum and PostgreSQL Wire Protocol ODBC Drivers add the same functionality that is found in the PostgreSQL ODBC Driver where unknown sizes can be listed as "longest" as described in this page: http://www.postgresql.org/message-id/attachment/15329/config.html Unknown Sizes: This controls what SQLDescribeCol and SQLColAttributes will return as to precision for character data types (varchar, text, and unknown) in a result set when the precision is unknown. This was more of a workaround for pre-6.4 versions of PostgreSQL not being able to return the defined column width of the varchar data type . Maximum : Always return the maximum precision of the data type. Dont Know : Return "Don't Know" value and let application decide. Longest : Return the longest string length of the column of any row. Beware of this setting when using cursors because the cache size may not be a good representation of the longest column in the cache. The reason for this enhancement is that they don't want to manually set the values for "Max Char Size", "Max Varchar Size", and "Max Long Varchar Size" in their ODBC DSN since these sizes can vary over time and it would require an administrator to modify the DSN accordingly.
Continue reading...
Continue reading...