Re: Find rows with "timestamp out of range"

agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed

From: Samed YILDIRIM <samed@reddoc.net>
To: Saiful Muhajir <saifulmuhajir@gmail.com>
To: vinny <vinny@xs4all.nl>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Cc: pgsql-sql-owner@postgresql.org <pgsql-sql-owner@postgresql.org>
Subject: Re: Find rows with "timestamp out of range"
Date: Mon, 19 Jun 2017 11:37:34 +0300
Message-ID: <138161497861454@web44g.yandex.ru> (raw)
In-Reply-To: <CAA0dH_timQKR659Op4MG52oCOVrOdG9rfFh+-FUD6R-AwM4ahA@mail.gmail.com>
References: <CAA0dH_v08fBFWp+4TsRz8wESSp8zgKCL_Sdc-OVdA3vQd_XjUg@mail.gmail.com>
	<a1996168394c6d8a702b4cf9160f177e@xs4all.nl>
	<CAA0dH_timQKR659Op4MG52oCOVrOdG9rfFh+-FUD6R-AwM4ahA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

<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@gmail.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@xs4all.nl">vinny@xs4all.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>

view thread (8+ messages)  latest in thread

Message-ID: <138161497861454@web44g.yandex.ru>
Permalink:  ../138161497861454@web44g.yandex.ru/
Also on:    postgresql.org/message-id/138161497861454@web44g.yandex.ru

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: samed@reddoc.net, saifulmuhajir@gmail.com, vinny@xs4all.nl, pgsql-sql-owner@postgresql.org
  Subject: Re: Find rows with "timestamp out of range"
  In-Reply-To: <138161497861454@web44g.yandex.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox