From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | lars(at)ellebjerg(dot)net |
Cc: | PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14485: Error in copy from temp |
Date: | 2017-01-05 00:00:32 |
Message-ID: | CAB7nPqR=dv9OTbGt+ZsjwsvK=n76yb18__96uxWnbFjbKhmBNg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, Jan 4, 2017 at 11:15 PM, <lars(at)ellebjerg(dot)net> wrote:
> I believe I have experienced an error in copying from a temporary table.
>
> I have a csv-file with a column of ten-digit person registry numbers, some
> of which start with zero.
> I need to copy them to a column 'cpr' in a table, which also contains an id
> serial column.
> If I do this by copying them to a temp table with a single text column, and
> then inserting them into the permanent table, the initial zero is removed
> somewhere between the temp and the permanent table.
> If I do the same using a permanent table instead of the temp table, the copy
> works fine including the initial zeros.
>
> create temporary table t (x1 text);
>
> copy t (x1)
> from 'C:/CPR hjemmesygepleje.csv' delimiter ';' csv;
>
> insert into aeldrepleje.hjemmesygeplejemodtagere (cpr)
> select x1 from t;
>
> select * from aeldrepleje.hjemmesygeplejemodtagere;
>
>
> create table aeldrepleje.hspm (cpr text);
>
> copy aeldrepleje.hspm (cpr)
> from 'C:/CPR hjemmesygepleje.csv' delimiter ';' csv;
>
> insert into aeldrepleje.hjemmesygeplejemodtagere (cpr)
> select cpr from aeldrepleje.hspm;
>
> select * from aeldrepleje.hjemmesygeplejemodtagere;
Could you send a minimal data CSV set to reproduce your problem? That
would be helpful to look at what you reported here.
--
Michael
From | Date | Subject | |
---|---|---|---|
Next Message | Gwork | 2017-01-05 01:23:43 | Postgresql query HAVING do not work |
Previous Message | Pantelis Theodosiou | 2017-01-04 20:22:50 | Re: BUG #14486: Inserting and selecting interval have different constraints |