Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 210: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: select t.oid,
- 235: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: select t.oid, t.typname
- 244: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: select t.oid, t.typname, t.typbasetype
- 251: APP:[unknown] PID:43 TR:0 LOG: statement: begin
- 258: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: select id from region_type where label_region = UPPER($1) and type_region = UPPER($2)
- 259: APP:[unknown] PID:43 TR:0 DETAIL: parameters: $1 = 'НОВОСИБИРСКАЯ', $2 = 'ОБЛАСТЬ'
- 264: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: insert into region_type (type_region, label_region, label_region_translate) values (UPPER($1), UPPER($2), $3) on conflict do nothing
- 265: APP:[unknown] PID:43 TR:0 DETAIL: parameters: $1 = 'ОБЛАСТЬ', $2 = 'НОВОСИБИРСКАЯ', $3 = 'novosibirskaya'
- 1685: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: select id from region_type where label_region = UPPER($1) and type_region = UPPER($2)
- 1686: APP:[unknown] PID:43 TR:0 DETAIL: parameters: $1 = 'НОВОСИБИРСКАЯ', $2 = 'ОБЛАСТЬ'
- 1735: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 1736: APP:[unknown] PID:43 TR:0 DETAIL: parameters: $1 = '1115476088034'
- 1739: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
- 1740: APP:[unknown] PID:43 TR:0 DETAIL: parameters: $1 = '1115476088034', $2 = '2011-07-29'
- 1749: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 1750: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 1755: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from city_type where labe_city = UPPER($1) and type_city = UPPER($2)
- 1756: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'НОВОСИБИРСК', $2 = 'ГОРОД'
- 1771: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from street_type where type_street = UPPER($1) and label_street = UPPER($2)
- 1772: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'УЛИЦА', $2 = 'ГЕОДЕЗИЧЕСКАЯ'
- 1789: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into street_type (type_street, label_street) VALUES (UPPER($1), UPPER($2)) on conflict do nothing
- 1790: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'УЛИЦА', $2 = 'ГЕОДЕЗИЧЕСКАЯ'
- 1816: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from street_type where type_street = UPPER($1) and label_street = UPPER($2)
- 1817: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'УЛИЦА', $2 = 'ГЕОДЕЗИЧЕСКАЯ'
- 1850: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "addr_RF" (region_type_id, area_type_id, city_type_id, locality_type_id, street_type_id, "code_region") values ($1, $2, $3, $4, $5, $6) returning id
- 1851: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1', $2 = NULL, $3 = '1', $4 = NULL, $5 = '4', $6 = '54'
- 1950: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "addr_RF_USR_LE_type" ("Index", code_region, code_addr_cldr, house, housing, apartment, "addr_RF", "SRN_date", "SRN_date_corr") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 1951: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '630087', $2 = '54', $3 = '540000010000276', $4 = '23', $5 = NULL, $6 = '1', $7 = '3', $8 = '51', $9 = NULL
- 2030: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_addr_LE" ("addr_RF", "inf_des_chng_place") VALUES ($1, $2) returning id
- 2031: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '3', $2 = NULL
- 2102: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_TA" where "code_NO" = $1
- 2103: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5404'
- 2133: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2134: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '6185476515581'
- 2143: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
- 2144: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '6185476515581', $2 = '2018-09-12'
- 2165: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2166: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '6185476515581'
- 2195: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_recording_TA" ("INTP_INTP_P", "CRS", date_reg, "inf_TA", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5, $6) returning id
- 2196: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5404442236', $2 = '540401001', $3 = '2011-07-29', $4 = '1', $5 = '62', $6 = NULL
- 2268: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_org_PF" where "code_PF" = $1
- 2269: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '64006'
- 2284: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2285: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '2115476949069'
- 2304: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
- 2305: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '2115476949069', $2 = '2011-08-10'
- 2338: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2339: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '2115476949069'
- 2356: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_reg_PF" ("reg_num_PF", date_reg, "inf_org_PF", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5) returning id
- 2357: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '064006099542', $2 = '2011-08-02', $3 = '1', $4 = '72', $5 = NULL
- 2404: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2405: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 2420: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_share_cap (label_kind_cap, sum_cap, share_ruble, inf_less_share_cap, "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5, $6) returning id
- 2421: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'УСТАВНЫЙ КАПИТАЛ', $2 = '10000', $3 = NULL, $4 = NULL, $5 = '51', $6 = NULL
- 2464: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2465: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 2476: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_label_LE" ("label_LE_full", "label_LE_short", "SRN_date_corr", "SRN_date") VALUES ($1, $2, $3,$4) returning id
- 2477: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ ЮРИДИЧЕСКАЯ КОМПАНИЯ "АРАНТА"', $2 = 'ООО ЮК "АРАНТА"', $3 = NULL, $4 = '51'
- 2530: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "way_create_LE" where "code_way_create_LE" = $1
- 2531: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '11'
- 2542: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2543: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 2569: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_create_LE" ("main_SRN", "date_main_SRN", "reg_num", "date_reg", "label_reg_auth", "way_create_LE", "SRN_date", "SRN_date_corr") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) returning id
- 2570: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034', $2 = '2011-07-29', $3 = NULL, $4 = NULL, $5 = NULL, $6 = '1', $7 = '51', $8 = NULL
- 2599: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_org_SIF" where "code_SIF" = $1
- 2600: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5409'
- 2613: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2614: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '2115476938620'
- 2619: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
- 2620: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '2115476938620', $2 = '2011-08-08'
- 2631: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2632: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '2115476938620'
- 2639: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_reg_SIF" ("reg_num_SIF", date_reg, "inf_org_SIF", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5) returning id
- 2640: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '540904061754091', $2 = '2011-08-02', $3 = '1', $4 = '92', $5 = NULL
- 2682: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2683: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 2700: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_reg_org ("SRN_date", "code_NO", "label_NO", addr_reg_org) VALUES ($1, $2, $3, $4) returning id
- 2701: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '51', $2 = '5476', $3 = 'Межрайонная инспекция Федеральной налоговой службы № 16 по Новосибирской области', $4 = 'площадь Труда, 1, г. Новосибирск, 630108'
- 2730: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "way_stop_LE" where "code_way_stop_LE" = $1
- 2731: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '407'
- 2738: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
- 2739: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5476'
- 2750: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2751: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '6185476514360'
- 2768: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
- 2769: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '6185476514360', $2 = '2018-09-12'
- 2778: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 2779: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '6185476514360'
- 2796: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_stop_LE" ("date_term_UL", inf_reg_org, "way_stop_LE", "SRN_date") values ($1, $2, $3, $4) returning id
- 2797: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '2018-09-12', $2 = '2', $3 = '1', $4 = '99'
- 2896: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_LE" ("time", date_stat, "main_SRN", "date_main_SRN", "INTP", "CRS", "inf_OLF", "code_OLF", "full_label_OLF", "inf_label_LE", "inf_addr_LE", "inf_create_LE", inf_reg_org, inf_email, "inf_stop_LE", "inf_recording_TA", "inf_reg_SIF", "inf_reg_PF", inf_share_cap, inf_type_order,"share_cap_USR_LE", "inf_register_holder_JSC")
- 2899: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1558531068', $2 = '2018-09-12', $3 = '1115476088034', $4 = '2011-07-29', $5 = '5404442236', $6 = '540401001', $7 = 'ОКОПФ', $8 = '12300', $9 = 'Общества с ограниченной ответственностью', $10 = '16', $11 = '3', $12 = '18', $13 = '14', $14 = NULL, $15 = '4', $16 = '5', $17 = '11', $18 = '12', $19 = '14', $20 = NULL, $21 = NULL, $22 = NULL
- 3034: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from filenames where name = $1
- 3035: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'test.XML'
- 3062: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into infle_filenames (filename_id, "inf_LE_id") values ($1, $2) on conflict do nothing
- 3063: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1', $2 = '13'
- 3152: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_pos_P" set active = $1 where "inf_LE" = $2
- 3153: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'f', $2 = '13'
- 3176: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 3177: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 3212: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_P_USR_LE_type" where last_name = UPPER($1) and fisrt_name = UPPER($2) and patronymic = UPPER($3) and "INTP_P" = $4
- 3213: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'ВИШНЕВСКАЯ', $2 = 'ВИКТОРИЯ', $3 = 'ВАЛЕРЬЕВНА', $4 = '753005539096'
- 3220: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_P_USR_LE_type" ("SRN_date", "SRN_date_corr", last_name, fisrt_name, patronymic, "INTP_P") values ($1, $2, UPPER($3), UPPER($4), UPPER($5), $6) on conflict do nothing
- 3221: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '51', $2 = NULL, $3 = 'ВИШНЕВСКАЯ', $4 = 'ВИКТОРИЯ', $5 = 'ВАЛЕРЬЕВНА', $6 = '753005539096'
- 3242: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_P_USR_LE_type" where last_name = UPPER($1) and fisrt_name = UPPER($2) and patronymic = UPPER($3) and "INTP_P" = $4
- 3243: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'ВИШНЕВСКАЯ', $2 = 'ВИКТОРИЯ', $3 = 'ВАЛЕРЬЕВНА', $4 = '753005539096'
- 3254: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 3255: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 3278: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_pos ("SRN_date", "SRN_date_corr", "main_SRN_IndE", kind_pos, label_kind_pos, label_pos) values ($1, $2, $3, $4, $5, $6) returning id
- 3279: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '51', $2 = NULL, $3 = NULL, $4 = '02', $5 = 'Руководитель юридического лица', $6 = 'Директор'
- 3298: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 3299: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 3308: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: delete from "inf_pos_P" where "inf_LE" = $1 and "inf_P" = $2
- 3309: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '13', $2 = '11'
- 3322: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_pos_P" ("SRN_date_first", "inf_P", "inf_LE", inf_pos, inf_phone_num, upload_date, active) values ($1, $2, $3, $4, $5, $6, $7) returning id
- 3323: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '51', $2 = '11', $3 = '13', $4 = '12', $5 = NULL, $6 = '2018-09-12', $7 = 't'
- 3328: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_pos_P" set "ext_inf_inval_pos_P" = $1, ext_inf_disq = $2 where id = $3
- 3329: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'f', $2 = 'f', $3 = '11'
- 3344: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update inf_founder set active = $1 where "inf_LE" = $2
- 3345: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'f', $2 = '13'
- 3372: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_founder ("inf_LE", upload_date, active) values ($1, $2, $3) returning id
- 3373: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '13', $2 = '2018-09-12', $3 = 't'
- 3406: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 3407: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 3428: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into share_size (percent, fractional_decimal, fractional_simple) values ($1, $2, $3) returning id
- 3429: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '100', $2 = NULL, $3 = NULL
- 3456: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "share_cap_USR_LE_type" (share_size, "SRN_date", "SRN_date_corr", nomin_value) values ($1, $2, $3, $4) returning id
- 3457: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '11', $2 = '51', $3 = NULL, $4 = '10000'
- 3488: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 3489: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 3496: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 3497: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 3506: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_P_USR_LE_type" where last_name = UPPER($1) and fisrt_name = UPPER($2) and patronymic = UPPER($3) and "INTP_P" = $4
- 3507: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'ВИШНЕВСКАЯ', $2 = 'ВИКТОРИЯ', $3 = 'ВАЛЕРЬЕВНА', $4 = '753005539096'
- 3566: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_founder iff where "inf_LE" = $1 and exists(select 1 from "founder_P" where iff.id = "founder_P".inf_founder and "inf_P" = $2)
- 3567: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '13', $2 = '11'
- 3580: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: delete from "founder_P" where inf_founder = $1
- 3581: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = NULL
- 3586: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: delete from inf_founder where id = $1
- 3587: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = NULL
- 3596: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "founder_P" (inf_founder, "inf_P", "inf_trust_mng_LE", "inf_trust_mng_P", pers_charge_inherit) values ($1, $2, $3, $4, $5)
- 3597: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '11', $2 = '11', $3 = NULL, $4 = NULL, $5 = NULL
- 3604: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update inf_founder set "ext_inf_founder_P" = $1, "SRN_date_first" = $2, share_cap = $3, ext_inf_insf_data_found = $4, ext_inf_burd = $5 where id = $6
- 3605: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 't', $2 = '51', $3 = '11', $4 = 'f', $5 = 'f', $6 = '11'
- 3624: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select "inf_GCEA" from "inf_LE" where id = $1
- 3625: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '13'
- 3634: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_GCEA" (active) values ($1) returning id
- 3635: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 't'
- 3644: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_GCEA_type" where "code_GCEA" = $1 and "char_ver_GCEA" = $2
- 3645: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '69', $2 = '2014'
- 3654: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 3655: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 3662: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_GCEA_type" ("code_GCEA", "label_GCEA", "char_ver_GCEA") values ($1, $2, $3) on conflict do nothing
- 3663: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '69', $2 = 'Деятельность в области права и бухгалтерского учета', $3 = '2014'
- 3670: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_GCEA_type" where "code_GCEA" = $1 and "char_ver_GCEA" = $2
- 3671: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '69', $2 = '2014'
- 3680: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_GCEA" set "inf_GCEA_main" = $1, "SRN_date" = $2, "SRN_date_corr" = $3 where id = $4
- 3681: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '45', $2 = '51', $3 = NULL, $4 = '9'
- 3686: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_GCEA_type" where "code_GCEA" = $1 and "char_ver_GCEA" = $2
- 3687: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '70.22', $2 = '2014'
- 3698: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 3699: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '1115476088034'
- 3704: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_GCEA_type" ("code_GCEA", "label_GCEA", "char_ver_GCEA") values ($1, $2, $3) on conflict do nothing
- 3705: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '70.22', $2 = 'Консультирование по вопросам коммерческой деятельности и управления', $3 = '2014'
- 3708: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from "inf_GCEA_type" where "code_GCEA" = $1 and "char_ver_GCEA" = $2
- 3709: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '70.22', $2 = '2014'
- 3712: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_GCEA_add" ("inf_GCEA", "inf_GCEA_add", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4)
- 3713: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '9', $2 = '48', $3 = '51', $4 = NULL
- 3726: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_GCEA" set "ext_inf_GCEA_add" = true where id = $1
- 3727: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '9'
- 3744: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from kind_record_type where code_kind_record = $1
- 3745: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '11201'
- 3756: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
- 3757: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5476'
- 3766: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 3767: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '115476703000977', $2 = '1115476088034', $3 = '2011-07-29', $4 = '3', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
- 3792: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_certs ("SRN_date_cert_no_active", series_cert, number_cert, date_cert, "inf_record_USR") values ($1, $2, $3, $4, $5)
- 3793: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = NULL, $2 = '54', $3 = '004334200', $4 = '2011-07-29', $5 = '15'
- 3812: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 3813: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Р11001 Заявление о создании ЮЛ', $2 = NULL, $3 = '2011-07-22', $4 = '15'
- 3832: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 3833: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Устав ЮЛ (два)', $2 = NULL, $3 = '2011-07-18', $4 = '15'
- 3846: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 3847: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Решение о создании ЮЛ', $2 = '1', $3 = '2011-07-18', $4 = '15'
- 3868: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 3869: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Акт', $2 = NULL, $3 = NULL, $4 = '15'
- 3880: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 3881: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Заявление', $2 = NULL, $3 = NULL, $4 = '15'
- 3900: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 3901: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Документ об оплате государственной пошлины', $2 = '0087', $3 = '2011-07-22', $4 = '15'
- 3924: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 3925: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Платежный документ за предоставление содержащихся в государственном реестре сведений', $2 = '0089', $3 = '2011-07-22', $4 = '15'
- 3940: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
- 3941: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 't', $2 = 't', $3 = '15'
- 3976: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
- 3977: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5476'
- 3996: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from kind_record_type where code_kind_record = $1
- 3997: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '13200'
- 4010: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 4011: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '115476710000571', $2 = '2115476897270', $3 = '2011-07-29', $4 = '5', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
- 4050: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
- 4051: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'f', $2 = 'f', $3 = '20'
- 4084: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from kind_record_type where code_kind_record = $1
- 4085: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '13400'
- 4102: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
- 4103: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5476'
- 4110: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 4111: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '115476720001358', $2 = '2115476938620', $3 = '2011-08-08', $4 = '8', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
- 4142: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
- 4143: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'f', $2 = 'f', $3 = '23'
- 4172: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from kind_record_type where code_kind_record = $1
- 4173: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '13300'
- 4186: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
- 4187: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5476'
- 4204: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 4205: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '115476722001607', $2 = '2115476949069', $3 = '2011-08-10', $4 = '6', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
- 4236: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
- 4237: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'f', $2 = 'f', $3 = '27'
- 4276: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from kind_record_type where code_kind_record = $1
- 4277: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '14109'
- 4292: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into kind_record_type (code_kind_record, label_kind_record) VALUES ($1, $2) on conflict do nothing
- 4293: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '14109', $2 = 'Принятие регистрирующим органом решения о предстоящем исключении юридического лица из ЕГРЮЛ (недействующее юридическое лицо)'
- 4314: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from kind_record_type where code_kind_record = $1
- 4315: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '14109'
- 4332: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
- 4333: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5476'
- 4342: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 4343: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '150000155951973', $2 = '2185476922596', $3 = '2018-05-23', $4 = '14', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
- 4352: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 4353: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Решение о предстоящем исключении недействуюшего ЮЛ из ЕГРЮЛ', $2 = '3912', $3 = '2018-05-21', $4 = '30'
- 4368: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
- 4369: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 't', $2 = 'f', $3 = '30'
- 4392: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
- 4393: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5476'
- 4400: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from kind_record_type where code_kind_record = $1
- 4401: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '14404'
- 4416: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 4417: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '150000162174604', $2 = '6185476514360', $3 = '2018-09-12', $4 = '2', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
- 4432: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 4433: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Решение о предстоящем исключении недействуюшего ЮЛ из ЕГРЮЛ', $2 = '3912', $3 = '2018-05-21', $4 = '32'
- 4436: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 4437: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Справка об отсутствии движения средств по счетам или отсутствии открытых счетов', $2 = '39038-С', $3 = '2018-05-15', $4 = '32'
- 4444: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into inf_prov_docs (title_doc, num_doc, date_doc, "inf_record_USR") values ($1, $2, $3, $4)
- 4445: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'Справка о непредставлении ЮЛ в течение последних 12 месяцев документов отчетности', $2 = '39038-О', $3 = '2018-05-15', $4 = '32'
- 4454: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
- 4455: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 't', $2 = 'f', $3 = '32'
- 4464: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from kind_record_type where code_kind_record = $1
- 4465: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '13200'
- 4474: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: select id from inf_reg_org_type where "code_NO" = $1
- 4475: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '5476'
- 4478: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: insert into "inf_record_USR" (id_record, "SRN", date_record, kind_of_record, inf_reg_org, "SRN_date_corr_prev", "SRN_date_no_active_prev", inf_state_record, "inf_LE") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 4479: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = '150000162175790', $2 = '6185476515581', $3 = '2018-09-12', $4 = '5', $5 = '2', $6 = NULL, $7 = NULL, $8 = NULL, $9 = '13'
- 4494: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_record_USR" set ext_inf_prov_docs = $1, ext_inf_certs = $2 where id = $3
- 4495: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'f', $2 = 'f', $3 = '36'
- 4504: APP:[unknown] PID:43 TR:408852 LOG: execute <unnamed>: update "inf_LE" set inf_peasant_farm_next = $1, ext_inf_mng_org = $2, ext_inf_status = $3, "ext_inf_pos_P" = $5, ext_inf_founder = $6, ext_inf_license = $7, "inf_GCEA" = $8, ext_inf_subdivision = $9, ext_inf_reorg = $10, ext_inf_prev = $11, inf_peasant_farm_prev = $12, ext_inf_next = $13 where id = $4
- 4505: APP:[unknown] PID:43 TR:408852 DETAIL: parameters: $1 = 'f', $2 = 'f', $3 = 'f', $4 = '13', $5 = 't', $6 = 't', $7 = 'f', $8 = '9', $9 = 'f', $10 = 'f', $11 = 'f', $12 = 'f', $13 = 'f'
- 4540: APP:[unknown] PID:43 TR:408852 LOG: statement: commit
- 4565: APP:[unknown] PID:43 TR:0 LOG: statement: begin
- 4584: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: select id from "inf_org_PF" where "code_PF" = $1
- 4585: APP:[unknown] PID:43 TR:0 DETAIL: parameters: $1 = '75030'
- 4594: APP:[unknown] PID:43 TR:0 LOG: execute <unnamed>: insert into "inf_org_PF" ("code_PF", "label_PF") values ($1, $2) on conflict do nothing
- 4595: APP:[unknown] PID:43 TR:0 DETAIL: parameters: $1 = '75030', $2 = 'Управление Пенсионного фонда Российской Федерации по Кировскому району г.Екатеринбурга'
- 4611: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "inf_org_PF" where "code_PF" = $1
- 4612: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '75030'
- 4674: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 4675: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '2116670249991'
- 4694: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
- 4695: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '2116670249991', $2 = '2011-08-01'
- 4714: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 4715: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '2116670249991'
- 4722: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "inf_reg_PF" ("reg_num_PF", date_reg, "inf_org_PF", "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5) returning id
- 4723: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '075030114960', $2 = '2011-07-27', $3 = '16', $4 = '119', $5 = NULL
- 4742: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 4743: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '1116670019465'
- 4756: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
- 4757: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '1116670019465', $2 = '2011-07-25'
- 4774: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 4775: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '1116670019465'
- 4782: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into inf_share_cap (label_kind_cap, sum_cap, share_ruble, inf_less_share_cap, "SRN_date", "SRN_date_corr") values ($1, $2, $3, $4, $5, $6) returning id
- 4783: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'УСТАВНЫЙ КАПИТАЛ', $2 = '10000', $3 = NULL, $4 = NULL, $5 = '120', $6 = NULL
- 4802: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 4803: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '1116670019465'
- 4820: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "inf_label_LE" ("label_LE_full", "label_LE_short", "SRN_date_corr", "SRN_date") VALUES ($1, $2, $3,$4) returning id
- 4821: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ "ТЕХНОЛОГИИ СТЕКЛА"', $2 = 'ООО "ТЕХНОЛОГИИ СТЕКЛА"', $3 = NULL, $4 = '120'
- 4842: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "way_create_LE" where "code_way_create_LE" = $1
- 4843: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '11'
- 4852: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 4853: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '1116670019465'
- 4864: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "inf_create_LE" ("main_SRN", "date_main_SRN", "reg_num", "date_reg", "label_reg_auth", "way_create_LE", "SRN_date", "SRN_date_corr") VALUES ($1, $2, $3, $4, $5, $6, $7, $8) returning id
- 4865: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '1116670019465', $2 = '2011-07-25', $3 = NULL, $4 = NULL, $5 = NULL, $6 = '1', $7 = '120', $8 = NULL
- 4886: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from street_type where type_street = UPPER($1) and label_street = UPPER($2)
- 4887: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'УЛИЦА', $2 = '40-ЛЕТИЯ КОМСОМОЛА'
- 4906: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into street_type (type_street, label_street) VALUES (UPPER($1), UPPER($2)) on conflict do nothing
- 4907: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'УЛИЦА', $2 = '40-ЛЕТИЯ КОМСОМОЛА'
- 4916: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from street_type where type_street = UPPER($1) and label_street = UPPER($2)
- 4917: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'УЛИЦА', $2 = '40-ЛЕТИЯ КОМСОМОЛА'
- 4930: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from region_type where label_region = UPPER($1) and type_region = UPPER($2)
- 4931: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'СВЕРДЛОВСКАЯ', $2 = 'ОБЛАСТЬ'
- 4960: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into region_type (type_region, label_region, label_region_translate) values (UPPER($1), UPPER($2), $3) on conflict do nothing
- 4961: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'ОБЛАСТЬ', $2 = 'СВЕРДЛОВСКАЯ', $3 = 'sverdlovskaya'
- 9792: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from region_type where label_region = UPPER($1) and type_region = UPPER($2)
- 9793: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'СВЕРДЛОВСКАЯ', $2 = 'ОБЛАСТЬ'
- 9824: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 9825: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '1116670019465'
- 9854: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from city_type where labe_city = UPPER($1) and type_city = UPPER($2)
- 9855: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = 'ЕКАТЕРИНБУРГ', $2 = 'ГОРОД'
- 9870: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "addr_RF" (region_type_id, area_type_id, city_type_id, locality_type_id, street_type_id, "code_region") values ($1, $2, $3, $4, $5, $6) returning id
- 9871: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '11', $2 = NULL, $3 = '4', $4 = NULL, $5 = '19', $6 = '66'
- 9914: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "addr_RF_USR_LE_type" ("Index", code_region, code_addr_cldr, house, housing, apartment, "addr_RF", "SRN_date", "SRN_date_corr") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning id
- 9915: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '620072', $2 = '66', $3 = '660000010000010', $4 = '38', $5 = 'ЛИТЕР Д', $6 = NULL, $7 = '28', $8 = '120', $9 = NULL
- 9949: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "inf_addr_LE" ("addr_RF", "inf_des_chng_place") VALUES ($1, $2) returning id
- 9950: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '28', $2 = NULL
- 9997: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 9998: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '2156670570440'
- 10033: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "SRN_date_type" ("SRN", date_record) values ($1, $2) on conflict do nothing
- 10034: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '2156670570440', $2 = '2015-03-29'
- 10073: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "SRN_date_type" where "SRN" = $1
- 10074: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '2156670570440'
- 10101: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into inf_reg_org ("SRN_date", "code_NO", "label_NO", addr_reg_org) VALUES ($1, $2, $3, $4) returning id
- 10102: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '210', $2 = '6658', $3 = 'Инспекция Федеральной налоговой службы по Верх-Исетскому району г.Екатеринбурга', $4 = ',620014,,,Екатеринбург г,,Хомякова ул,4,,'
- 10138: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: select id from "inf_TA" where "code_NO" = $1
- 10139: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '6670'
- 10156: APP:[unknown] PID:43 TR:408855 LOG: execute <unnamed>: insert into "inf_TA" ("code_NO", "label_NO") values ($1, $2) on conflict do nothing
- 10157: APP:[unknown] PID:43 TR:408855 DETAIL: parameters: $1 = '6670', $2 = 'Инспекция Федеральной налоговой службы по Кировскому району г.Екатеринбурга'
- 13319: APP:[unknown] PID:43 TR:408855 ERROR: deadlock detected
- 13320: APP:[unknown] PID:43 TR:408855 DETAIL: Process 43 waits for ShareLock on transaction 408854; blocked by process 58.
- 13324: APP:[unknown] PID:43 TR:408855 HINT: See server log for query details.
- 13325: APP:[unknown] PID:43 TR:408855 CONTEXT: while inserting index tuple (0,32) in relation "inf_TA"
- 13326: APP:[unknown] PID:43 TR:408855 STATEMENT: insert into "inf_TA" ("code_NO", "label_NO") values ($1, $2) on conflict do nothing
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement