I have a query regarding, the postgres Sever failure, for eg say i am parsng a file and inserting rows into a table. Now while this opeartion is taking place the server crashes, or say the power goes off, or say someone kills the postmaster demon.
Any rows you have committed (and received a successful result code for) should still be there. Any rows you haven't committed will not be.
what happens to the rows that have been inserted till now? can we get a status of how many rows have been installed or not?
You can always do SELECT count(*) FROM my_table to see how many rows are in it.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
