date out of range for timestamp

Поиск
Список
Период
Сортировка
От David Rericha
Тема date out of range for timestamp
Дата
Msg-id 4D1A7AB3.4010008@healthcareoss.com
обсуждение исходный текст
Ответы Re: date out of range for timestamp  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: date out of range for timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Postgre installation issue
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: date out of range for timestamp