[GENERAL] How to flatten a database table

2010-06-22 Thread mai fawzy
Hi All, I have a table that has the following fields: IDMoney Date State 1 20 2010-01-01 done 2 10 2010-01-02done 3 . . . . n I need to select the values from this table to join them 2 another select statement but t

[GENERAL] Rollback Failure

2010-04-20 Thread mai fawzy
Hi all, I have a transaction where I get a rollback failure if a sql error is returned. I dont know why the rollback fails!! Does anyone have any suggestions or information about this case? Thanks & B.R, Mai Fawzy

Re: [GENERAL] Cause of error message?

2009-12-16 Thread Mai Fawzy
It gave me another error which is "RollBack Failed". Does anyone know why a rollback fails in the transaction? Thanks Alot, Mai Fawzy Bayless Kirtley wrote: > > An old app is giving a new error message. I query a table and make one > update. Later I come back to query the t

Re: [GENERAL] Cause of error message?

2009-12-16 Thread Mai Fawzy
I have a very similar case, I am using erlang with postgres. I began a transaction then make an insertion and then I got the error "ERROR: current transaction is aborted, commands ignored until end of transaction block" when i try any other query. When i added the rollback line, It gave me anothe