From: David Rericha <d.rericha@healthcareoss.com>
To: pgsql-admin@postgresql.org
Subject: date out of range for timestamp
Date: Tue, 28 Dec 2010 18:02:59 -0600
Message-ID: <4D1A7AB3.4010008@healthcareoss.com> (raw)
Dear postgresql.org members:
I have a 21 GB database in version 8.4.5 that is giving me a curious
error when I perform a query on one of the tables:
Table "public.moms_outside_report"
Column | Type | Modifiers
----------------------------+-----------------------------+-----------
outreport_id | integer | not null
outreport_date | date |
outreport_pat_id | integer |
outreport_phys_id | integer |
outreport_report_id | integer |
outreport_date_reviewed | timestamp without time zone |
outreport_reviewed_by_u_id | integer |
guid | character varying(255) |
create_user | character varying(255) |
create_date | timestamp without time zone |
modify_user | character varying(255) |
modify_date | timestamp without time zone |
outreport_rg_id | integer |
outreport_name_id | integer |
image_path_name | character varying(255) |
Indexes:
"moms_outside_report_pkey" PRIMARY KEY, btree (outreport_id)
Foreign-key constraints:
"fka4c8b3652195c01a" FOREIGN KEY (outreport_reviewed_by_u_id)
REFERENCES auth_user(u_id)
"fka4c8b365275c337c" FOREIGN KEY (outreport_name_id) REFERENCES
moms_report_name(name_id)
"fka4c8b3658486426e" FOREIGN KEY (outreport_pat_id) REFERENCES
moms_patient(pat_id)
"fka4c8b3659ce19048" FOREIGN KEY (outreport_report_id) REFERENCES
moms_image_report(ireport_id)
"fka4c8b365c628e66a" FOREIGN KEY (outreport_phys_id) REFERENCES
moms_physician(phys_id)
"fka4c8b365e1c244a6" FOREIGN KEY (outreport_rg_id) REFERENCES
moms_radiograph(rg_id)
select count(*) from moms_outside_report where outreport_date <=
'12/10/2010';
ERROR: date out of range for timestamp
Now, the interesting thing is that this error is not given with any date
parameter prior to 12/10/2010. Also, I selected the entire table into a
temp table without constraints and could not reproduce the error. If
any one has any insight, I would be most appreciative.
--
David J. Rericha
OSS, LLC
Projects Manager
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: d.rericha@healthcareoss.com
Subject: Re: date out of range for timestamp
In-Reply-To: <4D1A7AB3.4010008@healthcareoss.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox