Thanks. That's what I had thought, but I just wanted to make sure.
I'll use psql (or write a perl script).

On Sat, Jul 7, 2012 at 11:24 AM, Guillaume Lelarge
<guilla...@lelarge.info>wrote:

> 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
>
>

Reply via email to