Ticket #32 (defect)
Opened 2 years ago
Postgresql 8.4 Numeric Support
Status: new
| Reported by: | jplee@amip.com | Assigned to: | fumanchu |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | providers | Version: | |
| Keywords: | providers postgresql | Cc: | |
| Estimate (total hours): |
When trying to discover a table with a numeric field w/out precision or scale and error occurs:
File "/usr/lib/python2.6/site-packages/geniusql/objects.py", line 821, in discover
self._discover_table(table, conn)
File "/usr/lib/python2.6/site-packages/geniusql/objects.py", line 791, in _discover_table
for col in self._get_columns(table, conn):
File "/usr/lib/python2.6/site-packages/geniusql/providers/postgres.py", line 891, in _get_columns
dbtype.precision = int((row[4] >> 16) & 65535)
File "/usr/lib/python2.6/site-packages/geniusql/dbtypes.py", line 164, in _set_precision
(self, value, self.max_precision)) ValueError?: geniusql.providers.postgres.DECIMAL(): 65535 is greater than max precision 1000.
A patch is included with the fix.
Attachments
Change History
02/11/10 09:53:41: Modified by jplee@amip.com
- attachment geniusql-precision.patch added.
02/11/10 09:58:16: Modified by jplee@amip.com
- attachment geniusql-numeric.patch added.
*real fix* ignore the previous patch
psql 8.4 numeric fix