Re: [BUGS] Bug #664: Strange cursor behaviour with particular database schema

2002-05-12 Thread Tom Lane
[EMAIL PROTECTED] writes: > template1=> move -1 from foo; > MOVE 0 Not sure what you expected this to do, but the response should have clued you that it didn't do anything. I suspect you are looking for "MOVE BACKWARD 1 FROM foo" ... regards, tom lane --

[BUGS] Bug #666: vacuum dies when called from plpgsql after large delete

2002-05-12 Thread pgsql-bugs
Philip Warner ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description vacuum dies when called from plpgsql after large delete Long Description Large table (> 13M rows), nightly job deletes approx 0.5M rows, then does a vacuum. It look

Re: [BUGS] Bug #666: vacuum dies when called from plpgsql after large delete

2002-05-12 Thread Tom Lane
[EMAIL PROTECTED] writes: > vacuum dies when called from plpgsql after large delete VACUUM from plpgsql doesn't work period, because of transaction/memory management issues. I believe we recently accepted a patch to reject attempts to do it. regards, tom lane --