Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 44BE8133740B for ; Tue, 28 Dec 2010 20:09:49 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 99356-01 for ; Wed, 29 Dec 2010 00:09:43 +0000 (UTC) X-Greylist: delayed 00:06:38.767107 by SQLgrey-1.7.6 Received: from smtpauth05.prod.mesa1.secureserver.net (smtpauth05.prod.mesa1.secureserver.net [64.202.165.99]) by mail.postgresql.org (Postfix) with SMTP id 87A8A1336FA7 for ; Tue, 28 Dec 2010 20:09:41 -0400 (AST) Received: (qmail 839 invoked from network); 29 Dec 2010 00:03:01 -0000 Received: from unknown (216.81.197.13) by smtpauth05.prod.mesa1.secureserver.net (64.202.165.99) with ESMTP; 29 Dec 2010 00:03:00 -0000 Message-ID: <4D1A7AB3.4010008@healthcareoss.com> Date: Tue, 28 Dec 2010 18:02:59 -0600 From: David Rericha User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.15) Gecko/20101026 SUSE/3.0.10 Thunderbird/3.0.10 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: date out of range for timestamp Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201012/196 X-Sequence-Number: 36425 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