Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1BB1C475CE5 for ; Tue, 31 Dec 2002 12:31:59 -0500 (EST) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id AB2F84758FE for ; Tue, 31 Dec 2002 12:31:58 -0500 (EST) Received: by news.hub.org (Postfix, from userid 8) id 8DA3E43A572; Tue, 31 Dec 2002 12:31:58 -0500 (EST) From: "Jose" X-Newsgroups: comp.databases.postgresql.admin Subject: No Space left on Device Date: Tue, 31 Dec 2002 12:27:36 -0500 Organization: GFPS Lines: 19 Message-ID: Reply-To: "Jose" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 To: pgsql-admin@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/2 X-Sequence-Number: 6844 Hi there, I'm Jose From Canada, I'm working with PostgreSQL 7.2 on Linux Red hat 7.3 and when I try to create an object in the database, using PGAdmin or psql, I get this error. create index pp_key on pp (p1) ; Error: -2147467259 can not create object : no space left on device. But if I check the available space on disk from linux I have a lot, more than 4 GB and the table pp is empty. Any clues ??? what should I check ??? Thanks in advance