Hi Jose,
Double check that by making sure that all your linux partitions have
free disk.
df is the command to use.
Cheers,
Hadley
On Wed, 2003-01-01 at 06:28, 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 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Hadley Willan > Systems Development > Deeper Design Limited. +64(7)377-3328
hadley.willan@deeperdesign.co.nz > www.deeperdesign.com > +64(21)-28-41-463
Level 1, 4 Tamamutu St, PO Box 90, TAUPO 2730, New Zealand.