On Sat, 2012-07-07 at 10:45 -0500, Michael Shapiro wrote: > Is it possible to run an update in the background? I have an update to 23+ > million records that will very likely take a few hours. > Is it possible to issue the update in PgAdmin, and then exit PgAdmin and > have the update continue on the server?
No, that's not possible. As soon as you quit pgadmin, the connection is dropped, and your statement is rollbacked. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support