agora inbox for pgsql-sql@postgresql.orghelp / color / mirror / Atom feed
"Timestamp out of range" 2+ messages / 2 participants [nested] [flat]
* "Timestamp out of range" @ 2014-01-30 13:41 Sandeep Devan <sdevan@in.rm.com> 0 siblings, 1 reply; 2+ messages in thread From: Sandeep Devan @ 2014-01-30 13:41 UTC (permalink / raw) To: pgsql-sql Hi, We have a .Net application which stores data in PostgreSQL. We have a perfectly working code with PostgreSQL 8.3 and now we are trying to upgrade our PostgreSQL server from version 8.3 to 9.3 and our code seems to break. For connecting PostgeSQL we are using 'OLEDB'. The issue we are getting is "Timestamp out of range". When looked through the logs receiving weird timestamp "152085-04-28 06:14:51.818821". ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: "Timestamp out of range" @ 2014-01-30 15:25 Adrian Klaver <adrian.klaver@gmail.com> parent: Sandeep Devan <sdevan@in.rm.com> 0 siblings, 0 replies; 2+ messages in thread From: Adrian Klaver @ 2014-01-30 15:25 UTC (permalink / raw) To: Sandeep Devan <sdevan@in.rm.com>; pgsql-sql On 01/30/2014 05:41 AM, Sandeep Devan wrote: > Hi, > We have a .Net application which stores data in PostgreSQL. We have a > perfectly working code with PostgreSQL 8.3 and now we are trying to > upgrade our PostgreSQL server from version 8.3 to 9.3 and our code seems > to break. > For connecting PostgeSQL we are using ‘OLEDB’. > The issue we are getting is “Timestamp out of range”. When looked > through the logs receiving weird timestamp “152085-04-28 06:14:51.818821”. > From our application We are trying to pass a value from .Net code to > postgreSQL function which is of type timestamp. As we are using OLEDB > for connections, we are using parameter type as “OleDbType.DBTimeStamp” > and sending date time value from .Net code. This code works in > PostgreSQL 8.3 but breaks in 9.3. From the logs of Postgresql 9.3 the > parameter value which we are receiving is “152085-04-28 06:14:51.818821”. > We tried to execute the same function using ‘npgsql’ provider from > sample .net code by passing Date time value and giving parameter type as > “NpgsqlDbType.TimestampTZ” with this we are getting correct results. > From the logs of PostgreSQL the parameter values received at the > function is shown as “E'2014-01-30 12:17:50.804220'::timestamptz”. > Tried in other versions of postgresql i.e. 9.1, 9.2, 9.3 and was > breaking in all these versions. > Any Idea why this is breaking in other versions of PostgreSQL when > perfectly working in 8.3? A possible clue is that 8.3 was the last version in which the default storage for timestamps was double precision floating point. In subsequent versions the default storage is eight-byte integers. Could be OleDbType.DBTimeStamp and NpgsqlDbType.TimestampTZ differ in this regard. > Thanks, > Sandeep -- Adrian Klaver adrian.klaver@gmail.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-01-30 15:25 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-01-30 13:41 "Timestamp out of range" Sandeep Devan <sdevan@in.rm.com> 2014-01-30 15:25 ` Adrian Klaver <adrian.klaver@gmail.com>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox