[SL] Big trouble after server crash

[Stuart L. <sl...@cc...>]

The hard disk on my server crashed, and I now notice that the backup
server, which I had thought was mirroring the main server has many, many
duplicated records. (I guess the pg_restore command I was running
automatically wasn't working so well.) When I try to post a transaction
I get this message:

DBD::Pg::db do failed: ERROR: more than one row returned by a subquery
used as an expression

Error!
INSERT INTO acc_trans (trans_id, chart_id, amount,
transdate)
VALUES (36053,
(SELECT id FROM chart
WHERE accno = '4202'),
-20, '2008-11-20')
ERROR: more than one row returned by a subquery used as an expression

Does anyone know what I can do to fix this? A little postgres magic? The
business will grind to a halt unless I can get this going again. 

Please!!
-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.25-gentoo-r
"Our vision is to speed up time, eventually
 eliminating it."   -- Alex Schure