Re: [HACKERS] COPY is not working

2010-05-03 Thread Jan Wieck
On 4/30/2010 1:56 AM, Jaime Casanova wrote: 2010/4/30 Jaime Casanova jcasa...@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

Re: [HACKERS] COPY is not working

2010-05-03 Thread Tom Lane
Jan Wieck janwi...@yahoo.com writes: On 4/30/2010 1:56 AM, Jaime Casanova wrote: 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

Re: [HACKERS] COPY is not working

2010-05-03 Thread Jan Wieck
On 5/3/2010 10:51 PM, Tom Lane wrote: Jan Wieck janwi...@yahoo.com writes: On 4/30/2010 1:56 AM, Jaime Casanova wrote: 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

Re: [HACKERS] COPY is not working

2010-04-30 Thread Jaime Casanova
On Fri, Apr 30, 2010 at 12:56 AM, Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: Jaime Casanova jcasa...@systemguards.com.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

Re: [HACKERS] COPY is not working

2010-04-30 Thread Takahiro Itagaki
Jaime Casanova jcasa...@systemguards.com.ec wrote: ah! this is because COPY doesn't follow inherited tables... should it? Yes. You can use COPY (SELECT * FROM a) TO instead to copy all tuples. http://developer.postgresql.org/pgdocs/postgres/sql-copy.html | COPY can only be used with plain

Re: [HACKERS] COPY is not working

2010-04-30 Thread Jaime Casanova
On Fri, Apr 30, 2010 at 1:13 AM, Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: Jaime Casanova jcasa...@systemguards.com.ec wrote: ah! this is because COPY doesn't follow inherited tables... should it? Yes. You can use COPY (SELECT * FROM a) TO instead to copy all tuples.

Re: [HACKERS] COPY is not working

2010-04-30 Thread Cédric Villemain
2010/4/30 Jaime Casanova jcasa...@systemguards.com.ec: On Fri, Apr 30, 2010 at 1:13 AM, Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: Jaime Casanova jcasa...@systemguards.com.ec wrote: ah! this is because COPY doesn't follow inherited tables... should it? Yes. You can use COPY

Re: [HACKERS] COPY is not working

2010-04-30 Thread Tom Lane
Jaime Casanova jcasa...@systemguards.com.ec writes: COPY is not working on latest HEAD? I've added this to the COPY notes section: para commandCOPY/command only deals with the specific table named; it does not copy data to or from child tables. Thus for example literalCOPY

[HACKERS] COPY is not working

2010-04-29 Thread Jaime Casanova
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 -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 --

Re: [HACKERS] COPY is not working

2010-04-29 Thread Takahiro Itagaki
Jaime Casanova jcasa...@systemguards.com.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

Re: [HACKERS] COPY is not working

2010-04-29 Thread Jaime Casanova
2010/4/30 Jaime Casanova jcasa...@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? --