On Mon, Jan 25, 2010 at 1:16 PM, Herouth Maoz <hero...@unicell.co.il> wrote: > Well, I assume by the fact that eventually I get an "Unexpected end of file" > message for those queries, that something does go in and check them. Do you > have any suggestion as to how to cause the postgresql server to do so > earlier?
No, Postgres pretty intentionally doesn't check because checking would be quite slow. If this is a plpgsql function looping you can put a RAISE NOTICE in the loop periodically. I suppose you could write such a function and add it to your query but whether it does what you want will depend on the query plan. -- greg -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
