From: | David Rericha <d(dot)rericha(at)healthcareoss(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | date out of range for timestamp |
Date: | 2010-12-29 00:02:59 |
Message-ID: | 4D1A7AB3.4010008@healthcareoss.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-12-29 00:18:20 | Re: date out of range for timestamp |
Previous Message | Scott Marlowe | 2010-12-28 18:49:40 | Re: Postgre installation issue |