Hi.

I try to monitor a progress of the insert statement:
insert into table1
  (id,other fields)
select
  id+0*nextval('public.progress'),other fields

>From second session i run:

select nextval('public.progress');

but sequence 'progress' looks unchanged.
How to display number of processed rows ?


------------
pasman

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to