Re: [SQL] Plsql Function with error: No space left on device.

2001-06-27 Thread Tom Lane
"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/

Re: [SQL] Plsql Function with error: No space left on device.

2001-06-26 Thread Tom Lane
"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