logun daha kapsamlı bir kısmını aşağıya ekliyorum. 2023-07-07 14:35:22 +03 [5332]: [220-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: statement: BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED 2023-07-07 14:35:22 +03 [5332]: [221-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: execute : SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [222-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 DETAIL: parameters: $1 = '1', $2 = '1', $3 = '1', $4 = '1' 2023-07-07 14:35:22 +03 [5332]: [223-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.63", size 391876 2023-07-07 14:35:22 +03 [5332]: [224-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [225-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [226-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.82", size 52744 2023-07-07 14:35:22 +03 [5332]: [227-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [228-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [229-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.68", size 365024 2023-07-07 14:35:22 +03 [5332]: [230-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [231-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [232-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.78", size 48640 2023-07-07 14:35:22 +03 [5332]: [233-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [234-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [235-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.72", size 368502 2023-07-07 14:35:22 +03 [5332]: [236-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [237-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [238-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.77", size 49780 2023-07-07 14:35:22 +03 [5332]: [239-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [240-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [241-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.69", size 365774 2023-07-07 14:35:22 +03 [5332]: [242-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [243-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [244-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.86", size 46208 2023-07-07 14:35:22 +03 [5332]: [245-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [246-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [247-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.67", size 360236 2023-07-07 14:35:22 +03 [5332]: [248-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [249-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [250-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.85", size 46740 2023-07-07 14:35:22 +03 [5332]: [251-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [252-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [253-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.62", size 377120 2023-07-07 14:35:22 +03 [5332]: [254-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [255-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [256-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.79", size 48640 2023-07-07 14:35:22 +03 [5332]: [257-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [258-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [259-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.65", size 345182 2023-07-07 14:35:22 +03 [5332]: [260-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [261-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [262-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.89", size 45220 2023-07-07 14:35:22 +03 [5332]: [263-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [264-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [265-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.61", size 369432 2023-07-07 14:35:22 +03 [5332]: [266-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [267-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [268-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.80", size 49096 2023-07-07 14:35:22 +03 [5332]: [269-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [270-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [271-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.60", size 368002 2023-07-07 14:35:22 +03 [5332]: [272-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [273-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [274-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.88", size 47956 2023-07-07 14:35:22 +03 [5332]: [275-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [276-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [277-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.64", size 365766 2023-07-07 14:35:22 +03 [5332]: [278-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [279-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [280-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.76", size 48640 2023-07-07 14:35:22 +03 [5332]: [281-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [282-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [283-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.70", size 370036 2023-07-07 14:35:22 +03 [5332]: [284-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [285-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [286-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.87", size 49172 2023-07-07 14:35:22 +03 [5332]: [287-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [288-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [289-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.66", size 345088 2023-07-07 14:35:22 +03 [5332]: [290-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [291-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [292-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.75", size 45600 2023-07-07 14:35:22 +03 [5332]: [293-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [294-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [295-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.73", size 369046 2023-07-07 14:35:22 +03 [5332]: [296-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [297-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [298-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.81", size 49324 2023-07-07 14:35:22 +03 [5332]: [299-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [300-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [301-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.71", size 363628 2023-07-07 14:35:22 +03 [5332]: [302-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [303-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [304-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.83", size 46360 2023-07-07 14:35:22 +03 [5332]: [305-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [306-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [307-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.74", size 363646 2023-07-07 14:35:22 +03 [5332]: [308-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [309-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:22 +03 [5332]: [310-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp5332.84", size 49704 2023-07-07 14:35:22 +03 [5332]: [311-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "with cte_dual as ( SELECT I.ID AS "ILACID",E.ID AS "ETKENMADDEID" FROM boyut_2008.ILCEXCELBILGIAKTAR IB INNER JOIN boyut_2008.ILCILACLAR I on IB.BARKOD =I.BARKODU LEFT OUTER JOIN boyut_2008.ILCETKENMADDELER E ON coalesce(E.ADI,'-') = coalesce(IB.ETKENMADDE,'-') ) update boyut_2008.ILCILACLAR set ILCETKENMADDEID = IK1."ETKENMADDEID", GUNCELLEYENID = LGUNCELLEYENID, GUNCELLEMEZAMANI = current_timestamp from cte_dual as IK1 where IK1."ILACID" = boyut_2008.ILCILACLAR.ID and coalesce(IK1."ETKENMADDEID",0) <> coalesce(ILCETKENMADDEID,0)" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 57 at SQL statement 2023-07-07 14:35:22 +03 [5332]: [312-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:52 +03 [5332]: [313-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 ERROR: canceling statement due to user request 2023-07-07 14:35:52 +03 [5332]: [314-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 CONTEXT: SQL statement "update boyut_2008.ilcilaclar set etiketfiyati = letiketfiyati, depocufiyati = ldepocufiyati, imalatcifiyati = limalatcifiyati, fiyattarihi = lfiyattarihi, ilciskontoid = lilciskontoid, kamuiskontosu = lkamuiskontosu, kamuiskontosututari = lkamuiskontosututari, malfazlasi = lmalfazlasi, standartvade = lstandartvade::numeric, ilckdvtipi = lilckdvtipi, ilcfiyattipi = lilcfiyattipi, artiiskonto1 = lartiiskonto1, artiiskonto2 = lartiiskonto2, guncellemezamani = current_timestamp, guncelleyenid = lguncelleyenid, orjinaltarih = lorjinaltarih, alisiskonto1 = lalisiskonto1, alisiskonto2 = lalisiskonto2, alisiskonto3 = lalisiskonto3, alisiskonto4 = lalisiskonto4, alisiskonto5 = lalisiskonto5, alisiskonto6 = lalisiskonto6, satiskar1 = lsatiskar1, satiskar2 = lsatiskar2, ozelfiyat = lozelfiyat,firmaimalatfiyati = lfirmaimalatfiyati, gelecekfiyattarihi = lgelecektarih, gelecekfiyat = lgelecekfiyat where id = lilcilacidup" PL/pgSQL function boyut_2008."ilac$up_ilcilaclar_uygunfiyat"(bigint) line 100 at SQL statement PL/pgSQL function boyut_2008."ilac$in_ilcilacfiyatlari"(bigint,bigint,timestamp without time zone,bigint,character varying,numeric,numeric,numeric,numeric,bigint,character varying,character varying,character varying,numeric,numeric,numeric,character varying,timestamp without time zone,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,character varying,character varying,character varying,character varying,character varying) line 68 at EXECUTE SQL statement "select * from boyut_2008.ilac$in_ilcilacfiyatlari( LILCFIYATID::bigint, SATIR.ILCILACID::bigint, SATIR.GECERLILIKTARIHI ::timestamp without time zone, LGUNCELLEYENID::bigint, SATIR.STANDARTMALFAZLASI::character varying, SATIR.ETIKETFIYATI::numeric, SATIR.DEPOCUFIYATI::numeric, SATIR.IMALATCIFIYATI::numeric, SATIR.KAMUISKONTOSU::numeric, SATIR.ILCISKONTOID::bigint, SATIR.STANDARTVADE::character varying, SATIR.ILCKDVTIPI::character varying, SATIR.ILCFIYATTIPI::character varying, SATIR.ARTIISKONTO1::numeric, SATIR.ARTIISKONTO2::numeric, SATIR.KAMUISKONTOSUTUTARI::numeric, null::character varying, SATIR.GECERLILIKTARIHI::timestamp without time zone, SATIR.ALISISKONTO1::numeric, SATIR.ALISISKONTO2::numeric, SATIR.ALISISKONTO3::numeric, SATIR.ALISISKONTO4::numeric, SATIR.ALISISKONTO5::numeric, SATIR.ALISISKONTO6::numeric, SATIR.SATISKAR1::numeric, SATIR.SATISKAR2::numeric, SATIR.OZELFIYAT::numeric, SATIR.GIRISPRIM::numeric, SATIR.CIKISPRIM::numeric, SATIR.DEPOCUKARI::numeric, SATIR.PESINISKONTOSU::numeric, SATIR.FIRMAIMALATFIYATI::numeric, SATIR.ALISVADE::character varying, SATIR.OZELSATISSEKLI::character varying, null::character varying, null::character varying, null::character varying )" PL/pgSQL function boyut_2008."vademecum$excelbilgiaktar"(bigint,bigint,bigint,bigint) line 96 at SQL statement 2023-07-07 14:35:52 +03 [5332]: [315-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 STATEMENT: SELECT * FROM boyut_2008.vademecum$excelbilgiaktar("latcaktar" := $1,"letkenmaddeaktar" := $2,"lfiyataktar" := $3,"lguncelleyenid" := $4) 2023-07-07 14:35:52 +03 [5332]: [316-1] user=postgres,db=postgres,app=[unknown],client=192.168.0.113 LOG: statement: ROLLBACK