date out of range for timestamp

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

Responses

Browse pgsql-admin by date

  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