Re: [GENERAL] drop/rename table and transactions

1999-11-28 Thread Jaco de Groot
Is it possible to achieve your goals by using things like "delete * from table1 where id!=stuffIwant" instead of dropping it? Yes, I think I better use delete statements instead of drop statements knowing PostgreSQL can't always handle drop/rename statements in transactions correctly

Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions

1999-11-28 Thread Jaco de Groot
in development. Jaco de Groot

[GENERAL] drop/rename table and transactions

1999-11-22 Thread Jaco de Groot
Hi, Every now and then I get the following error: cannot write block 0 of tablename [username] blind If this happens, all my database connections get this error when trying to access the database and I need to restart postgresql. The problem causing this error needs to be something like