pg_stat_progress_copy not working as intended
| От | asalias mark |
|---|---|
| Тема | pg_stat_progress_copy not working as intended |
| Дата | |
| Msg-id | CAJA4AWTdANknr0sZUm1FyiYWNxw4oLYY3s-4TLw_V3gbmuXdhQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: pg_stat_progress_copy not working as intended
|
| Список | pgsql-sql |
screenshot: https://prnt.sc/PROhSi8YOfc0
postgres=# CREATE TABLE copy_tab (a int, b text);
CREATE TABLE
postgres=# NSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
postgres-# 'a' || generate_series(1, 10) AS b;
ERROR: syntax error at or near "NSERT"
LINE 1: NSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
^
postgres=# INSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
generate_series(1, 10) ASpostgres-# 'a' || generate_series(1, 10) AS b;
INSERT 0 10
postgres=# COPY copy_tab TO '/tmp/copy_tab_data.txt';
COPY 10
postgres=# SELECT relid::regclass, command, type, bytes_processed, tuples_processed
postgres-# FROM pg_stat_progress_copy;
relid | command | type | bytes_processed | tuples_processed
-------+---------+------+-----------------+------------------
(0 rows)
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 14.2 (Ubuntu 14.2-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
(1 row)
CREATE TABLE
postgres=# NSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
postgres-# 'a' || generate_series(1, 10) AS b;
ERROR: syntax error at or near "NSERT"
LINE 1: NSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
^
postgres=# INSERT INTO copy_tab SELECT generate_series(1, 10) AS a,
generate_series(1, 10) ASpostgres-# 'a' || generate_series(1, 10) AS b;
INSERT 0 10
postgres=# COPY copy_tab TO '/tmp/copy_tab_data.txt';
COPY 10
postgres=# SELECT relid::regclass, command, type, bytes_processed, tuples_processed
postgres-# FROM pg_stat_progress_copy;
relid | command | type | bytes_processed | tuples_processed
-------+---------+------+-----------------+------------------
(0 rows)
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 14.2 (Ubuntu 14.2-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit
(1 row)
But I should get:
SELECT relid::regclass, command, type, bytes_processed, tuples_processed FROM pg_stat_progress_copy; relid | command | type | bytes_processed | tuples_processed
----------+---------+------+-----------------+------------------ copy_tab | COPY TO | FILE | 52 | 10
(1 row)Why are things not working as intended?
В списке pgsql-sql по дате отправления: