LOG: statement: set datestyle='ISO'
LOG: statement: INSERT INTO cc_logpayment (card_id, date, payment) values ('1', '2006-12-03 14:48:51', '111')
LOG: statement: SELECT cc_logpayment.id FROM cc_logpayment WHERE oid='32784'
LOG: statement: select oid,typname from pg_type
LOG: statement: set datestyle='ISO'
LOG: statement: SELECT username, date, payment, cc_logpayment.id FROM cc_logpayment LEFT JOIN cc_card ON cc_card.id=card_id ORDER BY id ASC LIMIT 10 OFFSET 0
LOG: statement: select oid,typname from pg_type
LOG: statement: SELECT count(*) FROM cc_logpayment LEFT JOIN cc_card ON cc_card.id=card_id
I enabled logging for postgresql, the trace above is "billing -> add new payment ... I added 111 roubles to card number 1, only table cc_logpayment was affected by such procedure, actual balance of the card was unchanged however.
Is actual balance supposed to be changed right after billing -> add new payment, or some other action should be done in order to achive that ?
|