update table an progress

[lao]

Hi,
Is it possible tp have an event for update table with uniquery?
for example i have a big table to update and i want a progressbar to indicate the update progress, the sql request is like this (i use dblink and postgresql database:


update mytable set
mytable.id = myservertable.id,
mytable.name= myservertable.name,
mytable.surname= myservertable.surname
from dblink('host=myserver port=5432 user=myuser dbname=mydb password=mypassword',
'SELECT id,name,surname
FROM myservertable'
) as myservertable(
id INTEGER,
name VARCHAR(225),
surname VARCHAR(225)
)
where
mytable.id = myservertable.id
and
(
mytable.name is distinct from myservertable.name or
mytable.surname is distinct from myservertable.surname
)


regards,
Lao

[AlexP]

Hello,

When editing data in a local database, you can retrieve events using UniAlerter and by implementing a trigger, in which the NOTIFY command is executed. For work via dblink, such functionality is not supported