Problem after upgrade to 8.4.1 - Mailing list pgsql-admin

Hi<b>!</b><br /> Probably this post should be sent on "bugs" list but I'm subscribed only here and on preformance@<br
/>Any way:<br /><br /> Last week we upgraded our database server from 8.3 to 8.4.1 (nothing more changed).<br />
Postgresql-8.4was build in exactly the same environment like 8.3 was.<br /><br /> Problem: we have an application that
retrievesscans (100 files in pack), looks for barcodes inside them and tries to assign them to the records.<br /> In
addition,some data is transferred to another schema ("b").<br /> This transaction is quite long... but worked perfectly
on8.3 now transformation ended like below :-(<br /><br /> 32096][azawadzki][2009-10-04 16:59:27 CEST][0] LOG:  execute
S_1:BEGIN<br /> [32096][azawadzki][2009-10-04 16:59:27 CEST][0] LOG:  execute <unnamed>: SELECT * FROM
scan_document_imageWHERE scan_session_id = $1 AND received_document_id IS NULL AND status_id <> 2 ORDER BY id<br
/>[32096][azawadzki][2009-10-04 16:59:27 CEST][0] DETAIL:  parameters: $1 = '2063'<br /> [32100][[unknown]][2009-10-04
16:59:30CEST][0] LOG:  connection received: host=192.168.134.11 port=46240<br /> [32101][[unknown]][2009-10-04 16:59:30
CEST][0]LOG:  connection received: host=192.168.134.11 port=46241<br /> [32100][region][2009-10-04 16:59:30 CEST][0]
LOG: connection authorized: user=region database=qs<br /> [32101][region][2009-10-04 16:59:30 CEST][0] LOG:  connection
authorized:user=region database=qs<br /> [32102][[unknown]][2009-10-04 16:59:30 CEST][0] LOG:  connection received:
host=192.168.134.11port=46242<br /> [32102][region][2009-10-04 16:59:30 CEST][0] LOG:  connection authorized:
user=regiondatabase=qs<br /> [32096][azawadzki][2009-10-04 16:59:33 CEST][0] LOG:  execute <unnamed>: SELECT *
FROMprintout_copy WHERE id = $1<br /> [32096][azawadzki][2009-10-04 16:59:33 CEST][0] DETAIL:  parameters: $1 =
'581832'<br/> [32096][azawadzki][2009-10-04 16:59:33 CEST][0] LOG:  execute <unnamed>: INSERT INTO
received_document    (id ,
scan_session_id,printout_copy_id,printout_id,receive_user,receive_tmstp,received_document_type_id     )     VALUES (<br
/>        DEFAULT  , $1, $2, $3, $4, $5, $6       )     RETURNING id AS id<br /><br /> [...]<br /><br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>:  UPDATE b.person SET
last_person_hist_id= $1, history_generate_id = 0 WHERE id = $2<br /> [32096][azawadzki][2009-10-04 17:00:46
CEST][970426]DETAIL:  parameters: $1 = '1374223', $2 = '658040'<br /> [32096][azawadzki][2009-10-04 17:00:46
CEST][970426]LOG:  execute <unnamed>:  SET CONSTRAINTS b.last_person_hist_id_fkey IMMEDIATE<br /><br /> Last well
donecommand (before was ~50 sets like this one)<br /> And here is last set of commands in transaction<br /><br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM uzytk WHERE login = $1
ORDERBY id LIMIT 1<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = 'agencja'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM
b.person_identity_documentWHERE  person_id = $1 AND series = $2 AND number = $3  AND updating_tmstp < $4  ORDER BY
updating_tmstpDESC LIMIT 1<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 =
'658040',$2 = 'AHZ', $3 = '056074', $4 = '2009-09-22 15:59:22.9133+02'<br /> [32096][azawadzki][2009-10-04 17:00:46
CEST][970426]LOG:  execute <unnamed>: INSERT INTO b.person_identity_document     (id ,
person_id,person_hist_id,hq_user_id,kind_id,series,number,issued_by,issue_place,issue_date,validity_date,registration_tmstp,updating_tmstp      
)    VALUES (          DEFAULT  , $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12    )     RETURNING id AS id<br
/><br/> HIDDEN VALUES<br /><br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute <unnamed>:
SELECT* FROM zobow WHERE kredytob=$1<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1
='3139017'<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM
uzytkWHERE login = $1 ORDER BY id LIMIT 1<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL: 
parameters:$1 = 'agencja'<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute <unnamed>:
SELECT* FROM b.person_obligation WHERE  person_id = $1    AND obligation_type_id = $2    AND total_amount = $3    AND
monthly_amount= $4    AND start_date = $5    AND end_date = $6    AND bank_name_id = $7    AND bank_name_other = $8   
ANDcurrency_id  = $9    AND updating_tmstp < $10  ORDER BY updating_tmstp DESC LIMIT 1<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] DETAIL:  parameters: $1 = '658040', $2 = '1', $3 = '0', $4 = '150',
$5= NULL, $6 = NULL, $7 = '-1', $8 = '', $9 = '1', $10 = '2009-09-22 15:59:22.9133+02'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: INSERT INTO b.person_obligation    
(id,
person_id,person_hist_id,registration_tmstp,updating_tmstp,hq_user_id,obligation_type_id,total_amount,monthly_amount,start_date,end_date,bank_name_id,bank_name_other,currency_id      
)    VALUES (          DEFAULT  , $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13       )     RETURNING id AS
id<br/><br /> HIDDEN VALUES<br /><br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute
<unnamed>:INSERT INTO b.person_credit     (id ,
person_id,person_hist_id,role_id,spouse_role_id,credit_data_id     )     VALUES (          DEFAULT  , $1, $2, $3, $4,
$5        RETURNING id AS id<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 =
'658040',$2 = '1374223', $3 = '1', $4 = '-1', $5 = '1102245'<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426]
LOG: execute <unnamed>:  SELECT *  FROM preselling p  WHERE true  AND p.id = -1<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>:  UPDATE kredytstatus SET
b_credit_data_id= 1102245 WHERE kredytid = 2787619<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: 
execute<unnamed>: SELECT    p.id as id,   k.id as borrower_id,   k.kredytid AS credit_id,   $1 AS
printout_type_idFROM kredytob k LEFT JOIN printout p ON (p.borrower_id = k.id AND p.printout_type_id = $2)  , kredytob
k2,kredyty c WHERE true  AND k2.id = $3  AND k.pesel = k2.pesel  AND k.kredytid = c.id   AND c.datazaw >=
'2008-3-4'    AND k.id <> k2.id       AND NOT EXISTS (SELECT 1 FROM received_document rd WHERE rd.printout_id =
p.id)AND NOT EXISTS (SELECT 1 FROM received_document_link rdl WHERE rdl.printout_id = p.id)<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] DETAIL:  parameters: $1 = '1', $2 = '1', $3 = '3139017'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: INSERT INTO received_document    
(id, scan_session_id,printout_copy_id,printout_id,receive_user,receive_tmstp,received_document_type_id )     VALUES
(<br/>         DEFAULT  , $1, $2, $3, $4, $5, $6       )     RETURNING id AS id<br /> [32096][azawadzki][2009-10-04
17:00:46CEST][970426] DETAIL:  parameters: $1 = '2063', $2 = '610563', $3 = '-1', $4 = NULL, $5 = '2009-10-04
17:00:45.701000+02:00:00', $6 = '2'<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute
<unnamed>:UPDATE scan_document_image SET received_document_id = $1, page_number = $2 WHERE id = $3<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] DETAIL:  parameters: $1 = '221532', $2 = '1', $3 = '242373'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM printout_copy WHERE id
=$1<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = '599066'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM printout_copy WHERE id
=$1<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = '610563'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM printout WHERE id =
$1<br/> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = '505437'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM scan_document_image
WHEREreceived_document_id = $1 AND status_id <> 2 ORDER BY page_number, id<br /> [32096][azawadzki][2009-10-04
17:00:46CEST][970426] DETAIL:  parameters: $1 = '221532'<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426]
LOG: execute <unnamed>: SELECT * FROM kredytob WHERE id = $1<br /> [32096][azawadzki][2009-10-04 17:00:46
CEST][970426]DETAIL:  parameters: $1 = '3136912'<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: 
execute<unnamed>: INSERT INTO historia (kredytid, statusrodz, statusid, fraud_status_id, visibility_id,
hq_visibility_id) VALUES ($1, $2, $3, $4, $5, $6)<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL: 
parameters:$1 = '2785554', $2 = '155', $3 = '-1', $4 = '-1', $5 = NULL, $6 = NULL<br /> [32096][azawadzki][2009-10-04
17:00:46CEST][970426] LOG:  execute <unnamed>: SELECT * FROM kredyty WHERE id=$1<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] DETAIL:  parameters: $1 = '2785554'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>:  select * from region where id =
$1<br/> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = '40'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM linie WHERE id = $1<br
/>[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = '599'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>:  SELECT tmstp_from FROM
borrower_histWHERE borrower_id = $1  UNION  SELECT tmstp_from FROM sygma_borrower_hist WHERE borrower_id = $2  ORDER BY
tmstp_from<br/> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = '3136912', $2 =
'3136912'<br/> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute <unnamed>:  SELECT *  FROM
borrower_histbh    LEFT JOIN sygma_borrower_hist bbh      ON (bh.borrower_id = bbh.borrower_id AND bbh.tmstp_from <=
$1AND bbh.tmstp_to > $2)  WHERE bh.borrower_id = $3    AND bh.tmstp_from <= $4    AND bh.tmstp_to > $5<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] DETAIL:  parameters: $1 = '2009-09-21 16:09:44.0363+02', $2 =
'2009-09-2116:09:44.0363+02', $3 = '3136912', $4 = '2009-09-21 16:09:44.0363+02', $5 = '2009-09-21 16:09:44.0363+02'<br
/>[32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute <unnamed>:  SELECT *  FROM borrower_hist bh 
WHEREbh.borrower_id = $1    AND bh.tmstp_from <= $2    AND bh.tmstp_to > $3<br /> [32096][azawadzki][2009-10-04
17:00:46CEST][970426] DETAIL:  parameters: $1 = '3136912', $2 = '2009-09-21 16:09:44.0363+02', $3 = '2009-09-21
16:09:44.0363+02'<br/> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute <unnamed>:  SELECT
exists(    SELECT 1    FROM kredytstatus ks, b.person p, b.person_credit pc    WHERE ks.kredytid = $1      AND
ks.b_credit_data_id= pc.credit_data_id      AND pc.person_id = p.id      AND p.pesel = $2  )<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] DETAIL:  parameters: $1 = '2785554', $2 = '46062203047'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>:  SELECT c.*  FROM kredytstatus ks,
b.credit_datac  WHERE ks.kredytid = $1    AND ks.b_credit_data_id = c.id<br /> [32096][azawadzki][2009-10-04 17:00:46
CEST][970426]DETAIL:  parameters: $1 = '2785554'<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG: 
execute<unnamed>: SELECT * FROM uzytk WHERE login = $1 ORDER BY id LIMIT 1<br /> [32096][azawadzki][2009-10-04
17:00:46CEST][970426] DETAIL:  parameters: $1 = 'postdb'<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426]
LOG: execute <unnamed>: INSERT INTO b.credit_data     (id ,
hq_user_id,product_id,instalment_number,apply_bureau_id,bureau_id,agency_id,region_id,apply_region_id,multika_id,bureau_category_id,apply_date,export_from_agency_tmstp,preparatory_gross_credit_amount,preparatory_applied_net_credit_amount,preparatory_consolidation_amount,payment_form_id,payee_account_name,payee_account_no,payee_account_bank_name,giro_authorization_id,preparatory_insurance_id,telecredit_id,head_office_operator_id,preselling_id,cc_salary_preselling_id,credit_commission_id,marketing_source_id,cc_user_id,agency_user_id     
)    VALUES (          DEFAULT  , $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19,
$20,$21, $22, $23, $24, $25, $26, $27, $28, $29       )     RETURNING id AS id<br /><br /> HIDDEN VALUES<br /><br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM b.person WHERE pesel =
$1<br/> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = '46062203047'<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM uzytk WHERE login = $1
ORDERBY id LIMIT 1<br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] DETAIL:  parameters: $1 = 'agencja'<br
/><br/> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute <unnamed>: SELECT * FROM d_citizenship
WHEREtrue    ORDER BY (CASE WHEN id=-1 THEN 0 ELSE 1 END),           nazwa<br /> [32096][azawadzki][2009-10-04 17:00:46
CEST][970426]LOG:  execute <unnamed>:  SET CONSTRAINTS b.last_person_hist_id_fkey DEFERRED<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>: INSERT INTO b.person     (id ,
personal_data_registration_tmstp,extended_data_registration_tmstp,hq_user_id,objection_kind_id,objection_date,objection_tmstp,objection_user,objection_note,pesel,first_name,second_name,surname,birth_date,birthplace,language_id,nip,military_status_id,sex,maiden_name,mothers_maiden_name,marital_status_id,number_of_persons_in_family,number_of_dependants_in_family,education_id,education_kind_id,bank_relation_id,citizenship_id,legal_address_street_type_id,legal_address_street,legal_address_building_no,legal_address_flat_no,legal_address_postal_code,legal_address_post,legal_address_city,legal_address_province_id,legal_address_country_id,origin_country_id,property_ownership_form_id,property_type_id,residence_date,corresp_address_street_type_id,corresp_address_street,corresp_address_building_no,corresp_address_flat_no,corresp_address_postal_code,corresp_address_post,corresp_address_city,corresp_address_province_id,corresp_address_country_id,corresp_address_add_phone_no,phone_operator
_id,phone_area,phone_no,add_phone_no,phone_kind_id,phone_verification_result_id,mobile_phone_operator_id,mobile_area,mobile_no,add_mobile_phone_no,mobile_kind_id,mobile_active_id,office_phone_number,email,fax,net_basic_salary_amount,net_premium_salary_amount,income_document_id,attached_income_document_id,attached_income_document_other,primary_income_source_type_id,employment_sector_id,annuity_closing_date,annuity_symbol,annuity_no,annuity_start_date,annuity_amount,job_position_id,profession_id,profession_other,job_position_name,receiving_income_start_date,receiving_income_type_id,income_source_verification_result_id,pension_no,pension_symbol,pension_amount,pension_start_date,previous_employment_start_date,previous_employment_end_date,seniority_years,seniority_months,firm_department,firm_legal_status_id,firm_name,firm_nip,firm_registriation_no,firm_regon,firm_street_type_id,firm_street,firm_building_no,firm_flat_no,firm_postal_code,firm_post,firm_city,firm_province_id,firm_cou
ntry_id,firm_phone_area,firm_phone_no,firm_phone_ext,add_firm_phone_no,firm_phone_verification_result_id,firm_mobile_area,firm_mobile_no,firm_mobile_kind_id,firm_second_mobile_area,firm_second_mobile_number,firm_second_mobile_kind_id,firm_fax_area,firm_fax_no,work_start_date,work_end_date,salary_currency_id,employment_certificate_signer_name,employment_certificate_signer_job_position_id,employment_certificate_signer_job_position_other,employment_certificate_date,business_activity_name,business_activity_shortname,business_activity_taxation_accounting_form_id,business_activity_nip,business_activity_regon,business_activity_street,business_activity_building_no,business_activity_flat_no,business_activity_postal_code,business_activity_post,business_activity_city,business_activity_province_id,business_activity_phone_area,business_activity_phone_no,business_activity_phone_ext,business_activity_mobile_area,business_activity_mobile_no,business_activity_mobile_kind_id,business_activity_
net_income,business_activity_gross_income,business_activity_start_date,farmer_income_amount,income_judicial_proceeding_status_id,firm_termination_status_id,firm_insolvency_status_id,tax_arrear_status_id,zus_arrear_status_id,work_agreement_probation_status_id,employment_termination_status_id,ais_income_amount,ais_type_id,ais_employment_sector_id,ais_currency_id,ais_work_start_date,ais_work_end_date,ais_profession_id,ais_profession_other,ais_verification_result_id,ais_firm_name,ais_firm_street_type_id,ais_firm_street,ais_firm_building_no,ais_firm_flat_no,ais_firm_postal_code,ais_firm_post,ais_firm_city,ais_firm_province_id,ais_firm_phone_area,ais_firm_phone_no,ais_firm_phone_ext,ais_firm_phone_verification_result_id,ais_firm_mobile_area,ais_firm_mobile_no,ais_firm_mobile_kind_id,ais_firm_legal_status_id,ais_firm_taxation_accounting_form_id,ais_firm_nip,ais_firm_regon,ais_firm_registriation_no,personal_account_status_id,personal_account_period_id,personal_account_creation_date,p
ersonal_account_number,personal_account_bank_name,has_credit_card_id,property_total_value,burdened_mortgage_id,burdened_mortgage_amount,financial_assets_total_value,life_insurance_count,life_insurance_total_value,qs_processing_allowed_date,qs_marketing_processing_allowed_date,qs_cooperate_processing_allowed_id,qs_cooperate_processing_allowed_date,insurance_processing_allowed_id,insurance_processing_allowed_date,external_verification_processing_allowed_id,external_verification_processing_allowed_date,statistic_processing_allowed_id,statistic_processing_allowed_date,non_personal_details_processing_allowed_id,non_personal_details_processing_allowed_date,electronic_advertising_allowed_id,electronic_advertising_allowed_date,field_of_knowledge,resolution_property_id,current_overtime_gross_income_amount,current_bonus_gross_income_amount,current_extras_gross_income_amount,current_commission_gross_income_amount,current_other_gross_income_amount     
)    VALUES (          DEFAULT  , $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19,
$20,$21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43,
$44,$45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67,
$68,$69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91,
$92,$93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112,
$113,$114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132,
$133,$134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152,
$153,$154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172,
$173,$174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192,
$193,$194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212,
$213,$214, $215, $216, $217, $218, $219 )     RETURNING id AS id<br /><br /> HIDDEN VALUES<br /><br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] LOG:  execute <unnamed>:  INSERT INTO b.person_hist ( id ,
personal_data_registration_tmstp,extended_data_registration_tmstp,hq_user_id,objection_kind_id,objection_date,objection_tmstp,objection_user,objection_note,pesel,first_name,second_name,surname,birth_date,birthplace,language_id,nip,military_status_id,sex,maiden_name,mothers_maiden_name,marital_status_id,number_of_persons_in_family,number_of_dependants_in_family,education_id,education_kind_id,bank_relation_id,citizenship_id,legal_address_street_type_id,legal_address_street,legal_address_building_no,legal_address_flat_no,legal_address_postal_code,legal_address_post,legal_address_city,legal_address_province_id,legal_address_country_id,origin_country_id,property_ownership_form_id,property_type_id,residence_date,corresp_address_street_type_id,corresp_address_street,corresp_address_building_no,corresp_address_flat_no,corresp_address_postal_code,corresp_address_post,corresp_address_city,corresp_address_province_id,corresp_address_country_id,corresp_address_add_phone_no,phone_operator
_id,phone_area,phone_no,add_phone_no,phone_kind_id,phone_verification_result_id,mobile_phone_operator_id,mobile_area,mobile_no,add_mobile_phone_no,mobile_kind_id,mobile_active_id,office_phone_number,email,fax,net_basic_salary_amount,net_premium_salary_amount,income_document_id,attached_income_document_id,attached_income_document_other,primary_income_source_type_id,employment_sector_id,annuity_closing_date,annuity_symbol,annuity_no,annuity_start_date,annuity_amount,job_position_id,profession_id,profession_other,job_position_name,receiving_income_start_date,receiving_income_type_id,income_source_verification_result_id,pension_no,pension_symbol,pension_amount,pension_start_date,previous_employment_start_date,previous_employment_end_date,seniority_years,seniority_months,firm_department,firm_legal_status_id,firm_name,firm_nip,firm_registriation_no,firm_regon,firm_street_type_id,firm_street,firm_building_no,firm_flat_no,firm_postal_code,firm_post,firm_city,firm_province_id,firm_cou
ntry_id,firm_phone_area,firm_phone_no,firm_phone_ext,add_firm_phone_no,firm_phone_verification_result_id,firm_mobile_area,firm_mobile_no,firm_mobile_kind_id,firm_second_mobile_area,firm_second_mobile_number,firm_second_mobile_kind_id,firm_fax_area,firm_fax_no,work_start_date,work_end_date,salary_currency_id,employment_certificate_signer_name,employment_certificate_signer_job_position_id,employment_certificate_signer_job_position_other,employment_certificate_date,business_activity_name,business_activity_shortname,business_activity_taxation_accounting_form_id,business_activity_nip,business_activity_regon,business_activity_street,business_activity_building_no,business_activity_flat_no,business_activity_postal_code,business_activity_post,business_activity_city,business_activity_province_id,business_activity_phone_area,business_activity_phone_no,business_activity_phone_ext,business_activity_mobile_area,business_activity_mobile_no,business_activity_mobile_kind_id,business_activity_
net_income,business_activity_gross_income,business_activity_start_date,farmer_income_amount,income_judicial_proceeding_status_id,firm_termination_status_id,firm_insolvency_status_id,tax_arrear_status_id,zus_arrear_status_id,work_agreement<br
/>
_probation_status_id,employment_termination_status_id,ais_income_amount,ais_type_id,ais_employment_sector_id,ais_currency_id,ais_work_start_date,ais_work_end_date,ais_profession_id,ais_profession_other,ais_verification_result_id,ais_firm<br
/>
ais_firm_name,ais_firm_street_type_id,ais_firm_street,ais_firm_building_no,ais_firm_flat_no,ais_firm_postal_code,ais_firm_post,ais_firm_city,ais_firm_province_id,ais_firm_phone_area,ais_firm_phone_no,ais_firm_phone_ext,ais_firm_phone_verification_result_id,ais_firm_mobile_area,ais_firm_mobile_no,ais_firm_mobile_kind_id,ais_firm_legal_status_id,ais_firm_taxation_accounting_form_id,ais_firm_nip,ais_firm_regon,ais_firm_registriation_no,personal_account_status_id,personal_account_period_id,personal_account_creation_date,personal_account_number,personal_account_bank_name,has_credit_card_id,property_total_value,burdened_mortgage_id,burdened_mortgage_amount,financial_assets_total_value,life_insurance_count,life_insurance_total_value,qs_processing_allowed_date,qs_marketing_processing_allowed_date,qs_cooperate_processing_allowed_id,qs_cooperate_processing_allowed_date,insurance_processing_allowed_id,insurance_processing_allowed_date,external_verification_processing_allowed_id,external
_verification_processing_allowed_date,statistic_processing_allowed_id,statistic_processing_allowed_date,non_personal_details_processing_allowed_id,non_personal_details_processing_allowed_date,electronic_advertising_allowed_id,electronic_advertising_allowed_date,field_of_knowledge,resolution_property_id,current_overtime_gross_income_amount,current_bonus_gross_income_amount,current_extras_gross_income_amount,current_commission_gross_income_amount,current_other_gross_income_amount,
person_id, tmstp_from,tmstp_to ) VALUES (       DEFAULT  , $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14,
$15,$16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38,
$39,$40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62,
$63,$64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86,
$87,$88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108,
$109,$110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128,
$129,$130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148,
$149,$150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168,
$169,$170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188,
$189,$190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208,
$209,$210, $211, $212, $213, $214, $215, $216, $217, $218, $219 , $220  , $221, $222 ) RETURNING id AS id<br /><br />
HIDDENVALUES<br /><br /> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute <unnamed>:  UPDATE
b.personSET last_person_hist_id = $1, history_generate_id = 0 WHERE id = $2<br /> [32096][azawadzki][2009-10-04
17:00:46CEST][970426] DETAIL:  parameters: $1 = '1374224', $2 = '658041'<br /> [32096][azawadzki][2009-10-04 17:00:46
CEST][970426]LOG:  execute <unnamed>:  SET CONSTRAINTS b.last_person_hist_id_fkey IMMEDIATE<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] ERROR:  could not open relation with OID 10027008<br />
[32096][azawadzki][2009-10-0417:00:46 CEST][970426] STATEMENT:   SET CONSTRAINTS b.last_person_hist_id_fkey
IMMEDIATE<br/> [32096][azawadzki][2009-10-04 17:00:46 CEST][970426] LOG:  execute S_2: ROLLBACK<br /><br /> I can
repeatthis behavior on all my test and production servers. If I run this last transaction block separately everything
worksfine.<br /> What could be wrong? Some bad adjustments? On the 8.3 works well...<br /><br /> ps. sorry for html but
IMHOlooks better.<br /><br /> -- <br /> Andrzej Zawadzki<br />