"David M. Richter" <[EMAIL PROTECTED]> writes:
> FATAL 2: ZeroFill(/usr/local/pgsql/data/pg_xlog/xlogtemp.30164) failed:
> No such file or directory
You ran out of disk space.
Yes, the error message is misleading. That's fixed in current sources.
See also
http://www.ca.postgresql.org/mhonarc/
"David M. Richter" <[EMAIL PROTECTED]> writes:
> The query works, but not right.(apart from the timeaspect)
> UPDATE image SET seriesoid = r.parentoid
> FROM image i JOIN relseries_image000 r ON i.chilioid=r.childoid;
You shouldn't mention "image i" in the FROM clause --- since image is
already