Re: Find rows with "timestamp out of range"

<div>Hi Saiful,</div><div> </div><div>Which version of PostgreSQL do you use?</div><div>Have you ever upgrade your Postgres from earlier major releases?</div><div>What was your upgrade method (dump/restore, pg_upgrade)?</div><div> </div><div>Best regards.</div><div> </div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>19.06.2017, 10:59, "Saiful Muhajir" &lt;saifulmuhajir(at)gmail(dot)com&gt;:</div><blockquote type="cite"><div><div style="font-family:arial,helvetica,sans-serif;">Yes, I am sure.</div><div style="font-family:arial,helvetica,sans-serif;"> </div><div style="font-family:arial,helvetica,sans-serif;">                                              Table "public.comments"<br />     Column      │            Type             │                        Modifiers                   <br />─────────────────┼─────────────────────────────┼──────────────────────────────────────────────────────────────<br /> comment_id      │ bigint                      │ not null default nextval('comments_comment_id_seq'::regclass)<br /> user_id         │ bigint                      │ not null<br /> status          │ smallint                    │ not null default 1<br /> message         │ text                        │ not null<br /> create_time     │ timestamp without time zone │ not null default now()<br /> update_time     │ timestamp without time zone │</div><div style="font-family:arial,helvetica,sans-serif;"> </div><div style="font-family:arial,helvetica,sans-serif;"> </div></div><div> <div><div><div><div><div><div><font color="#666666" size="2" face="tahoma, sans-serif">--</font></div><font color="#666666" size="2" face="tahoma, sans-serif">Regards,<br /><br /><a target="_blank" href="http://saifulmuhajir.web.id/">Saiful Muhajir</a></font></div></div></div></div></div> <div>On 19 June 2017 at 14:54, vinny <span>&lt;<a target="_blank" href="mailto:vinny(at)xs4all(dot)nl">vinny(at)xs4all(dot)nl</a>&gt;</span> wrote:<blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex;"><span>On <span>2017-06-19 09</span>:11, Saiful Muhajir wrote:</span><blockquote style="margin:0 0 0 0.8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi,<br /><br />I have a table with around 133 MILLION ROWS with two timestamp<br /><span>columns. While trying to copy some columns for a new database, using</span><br />\COPY , the error occurred with: TIMESTAMP OUT OF RANGE<br /><span>​While trying to​ figure out the rows containing the out of range<br />value, I am using this with no result:</span><br /> </blockquote><br />Are you sure that CREATED_AT is a timestamp? It seems odd that<br />the database would contain an invalid timestamp value in a timestamp field.</blockquote></div></div></blockquote>