Re: COPY is not working

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: COPY is not working
Date: 2010-04-30 06:00:18
Message-ID: s2r3073cc9b1004292300j946dc216p2bd6f1f24e810b7f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Apr 30, 2010 at 12:56 AM, Takahiro Itagaki
<itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
>
> Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> wrote:
>
>> COPY is not working on latest HEAD?
>> """
>> regression=# select * from a;
>>  aa
>> ----
>>  32
>>  56
>> (2 rows)
>>
>> regression=# COPY a TO '/tmp/copy_test';
>> COPY 0
>> """
>>
>> --
>
> Please send the actual test pattern and your environment information
> to reproduce the misbehavior. It works fine on my machine.
>

it's the regression database generated by "make installcheck", there
is an "a" table that is parent table (it has children), seems like
COPY is not getting the data from the inherited tables but only from
the parent

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Takahiro Itagaki 2010-04-30 06:13:07 Re: COPY is not working
Previous Message Takahiro Itagaki 2010-04-30 05:56:52 Re: COPY is not working