Skip to content

Problem with type #2

@WMP

Description

@WMP

I create database dump:

pg_dump -F c --blobs -f "ebicdb.dmp" ebicdb

And foreign table:

CREATE FOREIGN TABLE outqueue_y2014m01c (
    id_outqueue integer,
    id_route character(36),
    id_structure character(36),
    id_msg character(36),
    id_msg_parent character(36),
    id_msg_internal character varying(256),
    id_dst character(36),
    id_src character(36),
    date_in timestamp without time zone,
    date_out timestamp without time zone,
    status smallint,
    endpoint character varying(500),
    out_filename character varying(500),
    status_info text,
    message_type smallint,
    id_msg_link character(36),
    original_payload_checksum character(40),
    original_payload_name character varying(128)
) SERVER dump_server
  OPTIONS (
    file_name '/var/lib/postgresql/ebicdb.dmp',
    schema_name 'public',
    relation_name 'outqueue_y2014m01'
  )
;

When i want to execute:

select * from outqueue_y2014m01c;

i have error:

ERROR:  invalid input syntax for type timestamp: "2014-02-01 00.909"

When i execute select * from outqueue_y2014m01 on database ebicdb i have results without problem.

I can execute:

select * from outqueue_y2014m01c limit 10;
select * from outqueue_y2014m01c limit 100;
select * from outqueue_y2014m01c limit 99999;
select * from outqueue_y2014m01c limit 300032;

witout error, but i cannot execute:

select * from outqueue_y2014m01c limit 300033;
ERROR:  invalid input syntax for type timestamp: "2014-02-01 00.909"

This is row 300033 from normal database:

id_outqueue |               id_route               |
id_structure             |                id_msg |
id_msg_parent             | id_msg_internal |
id_dst                | id_src                |         date_in
| date_out         | status | endpoint | out_filename | status_info |
message_type | id_msg_link | original_payload_checksum         |
original_payload_name
-------------+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+-----------------+--------------------------------------+--------------------------------------+-------------------------+-------------------------+--------+----------+--------------+-------------+--------------+-------------+------------------------------------------+-----------------------
  2020502208 | 9aeebbdd-da32-4df1-881e-479477b20964 |
590e19a3-a184-46ac-b2ff-c5cf105f51c2 |
f8f931a2-fc4b-43cf-9315-bc3a3be81fa1 |
107abb92-3203-4331-b510-5d2088f14cd0 | 223/14/M        |
B1AA1BF7-0C1A-11DB-A11F-2D8072E8B6EB |
ca611421-3b01-4171-afd5-bce91c9e27a8 | 2014-02-01 00:21:24.909 |
2014-02-01 00:21:28.014 |     20 |          | |             |
7 |             | 396c2c24f6a02dfbb01840d1813b105388e1ce3d |
RPS_20140201_0015.TXT
(1 row)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions