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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
