Re: problem in Check in and check out

Posted by srinaththota on Feb 17, 2011; 9:52am
URL: http://ngl.70.s1.nabble.com/problem-in-Check-in-and-check-out-tp6027050p6035265.html

Some of the records I am able to modifying/deleting. but some of them are not. what could be the reason.
I have check the postgres logs it is showing me like this.

ERROR:  update or delete on "document" violates foreign key constraint "fk__cir_transaction__1bc8ed34" on "cir_transaction"

2011-02-17 15:04:05 DETAIL:  Key (accession_number,library_id)=(PH-45,1) is still referenced from table "cir_transaction".

whatever I am modifying/deleting the records are not on Circulation.

I also executed following line in pgadmin III.
update library_holdings set sublocation_id=1; It has given me following  message.

Query returned successfully: 493 rows affected, 78 ms execution time.

I dont know where to save that after executing the script. I just saved on my C Drive.

Please guide me.

srinath