Re: Find rows with "timestamp out of range"

From: vinny <vinny(at)xs4all(dot)nl>
To: Saiful Muhajir <saifulmuhajir(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-sql-owner(at)postgresql(dot)org
Subject: Re: Find rows with "timestamp out of range"
Date: 2017-06-19 07:54:26
Message-ID: a1996168394c6d8a702b4cf9160f177e@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2017-06-19 09:11, Saiful Muhajir wrote:
> Hi,
>
> I have a table with around 133 MILLION ROWS with two timestamp
> columns. While trying to copy some columns for a new database, using
> \COPY , the error occurred with: TIMESTAMP OUT OF RANGE
> ​While trying to​ figure out the rows containing the out of range
> value, I am using this with no result:
>

Are you sure that CREATED_AT is a timestamp? It seems odd that
the database would contain an invalid timestamp value in a timestamp
field.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Saiful Muhajir 2017-06-19 07:57:58 Re: Find rows with "timestamp out of range"
Previous Message Saiful Muhajir 2017-06-19 07:11:18 Find rows with "timestamp out of range"