Try the "df -h" command to determine if this might be the case.
Jose wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
.
-- John Burski @HOME S.I.M.U. (Well, sometimes I am :) )
... and still searching for the cheese! ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org