Table "public.comments" Column │ Type │ Modifiers ─────────────────┼─────────────────────────────┼────────────────────────────────────────────────────────────── comment_id │ bigint │ not null default nextval('comments_comment_id_seq'::regclass) user_id │ bigint │ not null status │ smallint │ not null default 1 message │ text │ not null create_time │ timestamp without time zone │ not null default now() update_time │ timestamp without time zone │
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.