| From: | Peter Zeltins <peter(at)greatnowhere(dot)com> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: numeric type |
| Date: | 2008-07-29 21:23:33 |
| Message-ID: | 1217366613.5193.11.camel@peter-laptop |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
> > OK, I hear ya. How about allowing user to set the default precision and
> > scale values for "numeric" type? Not sure how this would be done in JDBC
> > world but should be doable.
>
> You could add URL parameters like unspecifiedNumericPrecision=1000 and
> unspecificedNumericScale=500, but the tradeoff is how much work is it to
> add these options to the URL parsing code and then pass them around, add
> it to the datasource implementation, add it to the documentation, and ...
>
> If there was some big important app that everyone wanted to use that blew
> up on this I'd bet we'd do it, but I haven't heard a whole lot of
> complaints about this problem.
I would assume this is not a major issue for most. Personally I ran into
this problem when writing automated PG->MS Access converter (Jackcess is
the only lib capable of creating MDB files on Linux/BSD) and it bailed
on numeric fields.
Peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Migowski | 2008-07-30 08:24:50 | Re: numeric type |
| Previous Message | Kris Jurka | 2008-07-29 18:37:30 | Re: GSSAPI/KRB5 and JDBC (again) |