Re: COPY is not working

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: COPY is not working
Дата
Msg-id 4BDF876B.3000009@Yahoo.com
обсуждение исходный текст
Ответ на Re: COPY is not working  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Ответы Re: COPY is not working  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: what is good solution for support NULL inside string_to_array function?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: max_standby_delay considered harmful