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