openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Curtis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2178) PostgresDictionary
Date Thu, 26 Apr 2012 14:38:16 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262642#comment-13262642
] 

Rick Curtis commented on OPENJPA-2178:
--------------------------------------

I vote to make the change, it seems like the right answer for Postgres. 

... that being said, are there older version of Postgres that don't support microsecond precision?
I couldn't find any user manuals that are pre-6.3.
                
> PostgresDictionary 
> -------------------
>
>                 Key: OPENJPA-2178
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2178
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.2.0
>            Reporter: Mark Struberg
>            Assignee: Mark Struberg
>             Fix For: 2.3.0
>
>
> We hit a problem that OpenJPA always rounds to the nearest 10ms for PostgreSQL. We found
the following old issue in which a workaround got outlined in OPENJPA-433
> But still the question remains: PostgreSQL is perfectly fine to store milliseconds, so
why does the PostgresDictionary line 146 sets:
> > datePrecision = CENTI;
> ?
> The generated TIMESTAMP type in PostgreSQL should even be able to store microseconds!
[1]
> And that seems to be the case since quite some time now (1999) [2].
> I'm really tempted to set this to MICRO; Anyone against it?
> [1] http://www.postgresql.org/docs/9.0/interactive/datatype-datetime.html
> [2] http://www.postgresql.org/docs/7.0/static/datatype1134.htm

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message