Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Find rows with "timestamp out of range" - Mailing list pgsql-sql

From vinny
Subject Re: [SQL] Find rows with "timestamp out of range"
Date
Msg-id a1996168394c6d8a702b4cf9160f177e@xs4all.nl
Whole thread Raw
In response to [SQL] Find rows with "timestamp out of range"  (Saiful Muhajir <saifulmuhajir@gmail.com>)
Responses Re: [SQL] Find rows with "timestamp out of range"  (Saiful Muhajir <saifulmuhajir@gmail.com>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Saiful Muhajir
Date:
Subject: [SQL] Find rows with "timestamp out of range"
Next
From: Saiful Muhajir
Date:
Subject: Re: [SQL] Find rows with "timestamp out of range"