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
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
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
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
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
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.
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
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
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
--
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
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?
--
11 matches
Mail list logo