Re: COPY is not working - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: COPY is not working
Date
Msg-id 4BDF876B.3000009@Yahoo.com
Whole thread Raw
In response to Re: COPY is not working  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Responses Re: COPY is not working
List pgsql-hackers
On 4/30/2010 1:56 AM, Jaime Casanova wrote:
> 2010/4/30 Jaime Casanova <jcasanov@systemguards.com.ec>:
>> Hi,
>>
>> 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
>> """
>>
> 
> ah! this is because COPY doesn't follow inherited tables... should it?

The TRUNCATE command's behavior was changed in that regard. What 
TRUNCATE did in 8.3 is now TRUNCATE ONLY in 8.4. I don't see a reason 
why COPY should not follow suit.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: what is good solution for support NULL inside string_to_array function?
Next
From: Bruce Momjian
Date:
Subject: Re: max_standby_delay considered harmful