Tom Lane wrote:
>
> Ed Loehr <eloehr@austin.rr.com> writes:
> >> Then, start this one in another bash window/terminal/whatever...
> >>
> >> % while test 1; do echo -n "`date`: "; psql -d pdb -c "vacuum analyze;
> >> select count(*) from foo;"; sleep 3; done
> >>
> >> This seems to consistently crash after the first vacuum with the
> >> following message:
>
> This is a known gotcha that's got nothing to do with any sort of
> concurrency. You can't safely send a VACUUM followed by anything
> else in a single query string.
Well, I thought that select count(*) might've been causing a problem, so
I experimented without it and found the same problem. Doesn't seem to
happen with 'vacuum'or 'vacuum analyze foo', only 'vacuum analyze'...
Regards,
Ed Loehr
