Hi, I run postgresql 7.0.3. I have a large table and i started to create an index on it. Unfortunately the diak space was not enough and got a message that the device was full. From this moment the table i tried to index has 0 rows. what is wrong? I tried ipcclean, postgres reboot, system reboot and etc. But there was no result. is there any way to restore the table without using the backup? Thanks! Rumen __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/