Received: from newmail.DKFZ-Heidelberg.DE (newmail.inet.dkfz-heidelberg.de [193.174.53.39]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5RBrPa37615 for ; Wed, 27 Jun 2001 07:53:25 -0400 (EDT) (envelope-from D.Richter@DKFZ-heidelberg.de) Received: from perkeo.inet.dkfz-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by newmail.DKFZ-Heidelberg.DE (8.9.3/8.9.3/DKFZ-8.9.3) with ESMTP id NAA18298; Wed, 27 Jun 2001 13:53:19 +0200 (MET DST) Received: from DKFZ-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by perkeo.inet.dkfz-heidelberg.de (980427.SGI.8.8.8/DKFZ-8.6.4) with ESMTP id NAA05909; Wed, 27 Jun 2001 13:51:29 +0200 (MDT) Message-ID: <3B39C8C1.96EE543C@DKFZ-heidelberg.de> Date: Wed, 27 Jun 2001 13:51:29 +0200 From: "David M. Richter" Organization: German Cancer Research Center X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: Richard Huxton , pgsql-sql@postgresql.org Subject: Re: Plsql Function with error: No space left on device. References: <3B36FB6E.1039F0D4@DKFZ-heidelberg.de> <005601c0fd60$db576740$1001a8c0@archonet.com> <3B388D05.C3919F0F@DKFZ-heidelberg.de> <3122.993567296@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="------------12D07DF0B16FA645632A000F" X-Archive-Number: 200106/430 X-Sequence-Number: 3727 This is a multi-part message in MIME format. --------------12D07DF0B16FA645632A000F Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! It works right. And the speed is acceptable. Great!!!! I used that Query on several table with a little smaller size. It worked. Thank You very much! But in the Query at the big table the following error occured: UPDATE image SET seriesoid = r.parentoid FROM relseries_image000 r WHERE image.chilioid = r.childoid; psql:restructure_join.sql:16: FATAL 2: ZeroFill(/usr/local/pgsql/data/pg_xl og/xlogtemp.22940) failed: No such file or directory pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. psql:restructure_join.sql:16: connection to server was lost The file /usr/local/pgsql/data/pg_xl og/xlogtemp.22940 doesn't exist on the disk. The same query on the other table works well. Why not at the bigger table? What wants the error announcment say? Do You know that kind of error? I did not found any hint in the Archiv of the mailing lists? I would be very gratful if anybody could give me a hint to clear the obstacle.! Thanks a lot David --------------12D07DF0B16FA645632A000F Content-Type: text/x-vcard; charset=us-ascii; name="D.Richter.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="D.Richter.vcf" begin:vcard url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A n:M. Richter;David x-mozilla-html:FALSE org:Deutsches Krebsforschungszentrum;Division Medizinische und Biologische Informatik version:2.1 email;internet:d.richter@dkfz-heidelberg.de adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;; x-mozilla-cpt:;-15296 fn:David M. Richter end:vcard --------------12D07DF0B16FA645632A000F--