Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkum7-0001c5-2f for pgsql-performance@arkaria.postgresql.org; Thu, 03 Dec 2020 20:00:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkum5-0006JP-OJ for pgsql-performance@arkaria.postgresql.org; Thu, 03 Dec 2020 20:00:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kkum5-0006JI-26 for pgsql-performance@lists.postgresql.org; Thu, 03 Dec 2020 20:00:21 +0000 Received: from sonic303-49.consmr.mail.ne1.yahoo.com ([66.163.188.175]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kkum1-0007rS-W0 for pgsql-performance@lists.postgresql.org; Thu, 03 Dec 2020 20:00:20 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1607025616; bh=VJiFDeze0ch+oUypBkZIkfuNeGGzhaWXgH5trGWSZXQ=; h=Date:From:To:Subject:References:From:Subject; b=ezgRk72bT+Of1rwQDMb6W7cAu2fhoBWoFRiUQY4SOc86oSt2KVhO+Ln/kab5hNV21u/4uv0/YZPPN9I+4dqOmybhWYeDxe29iwXD2uEe1jZk80B21V6921V/aXfwXVdNdUAZ+VfrG8quSfoi0DI+LOUytpXr/sJhwRJJEHStp7zqFDPSjvELzl716wlENX/8e0WLSJQ6DqvGg6aBzzsIi5qKFH4EIBrNPR6cD0iUXS47+We3Jgr8sFC2ANkpa7RaI3NBGv8s4XSFCwbl3/FM/NsNzArnErRxVuHbyc/3xcE4rc+EV3t72iajS+GO70BH3LReZfaymMgpjMkfHEn1rg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1607025616; bh=Dk5ZNf1z1ZTC/vZdlGdb4yXqotkhd/D3uH7dLqzyWqB=; h=Date:From:To:Subject:From:Subject; b=r708EgoivNo1LGWfV9NTbg4F1/22FarxYzt+R3za38dh/ax3lwpB/Zmd41EHdrIygn2d1wCPIbA3yBkaQWi6hiTu0VX9HdDdWarz0dflyI28xGRFLIUkT4U7Oq/b8oVmsImuahQeorAlfrPUJMOplXwLBvTSc6J171DpToeMmGW2mjEL8ksnCr0JFzjytG4rgV5eLP9aahkdbuSltTO2ruwQqf1MaQkUbV4P8H3Q2m8Hu7VU+uIcdMzfrhLnPPyuCCxLdy8I9c8jtc5r2hx0hkgkKLUrPGrpz0ti3+IJoXBsPzYKj5OXCYiJgxIrGbf1jGVaL6uZPzsB0cO4qpCylQ== X-YMail-OSG: tipxkbUVM1mK.GatfcOF.EAypKYdkgy21729kdAiG7wY04VomGf1yonEMfZjJZg tKUIEUQchQdw5T5hMebVgnQycG4a8ZWvvG_Er9sDDl0rcN6lXYJEz7hs3yEpwxgYALwE045ybeDr X0hXJs7rVmk.a66iFDZO7kMdR54JEhVmeeYatkAaQDPPdlgrx7B.mnlES8m3tsx6Sdcy.mWjXYbs pG1dHmEW_55HUU7lGCsLfycxVyMSi4FvzElUGdczXktgDHDa2PRqtlWSay4LSXz7mWQE4Ci1L.bk zHeflsRSaYjx6S09Ac_X7f3zYzmwXemNejFcu2IxMfiPKFNkIEJ8_FpC1cph8WaTuiou6dZ7pEr8 PxYdhCoy7SCIg2VqaPnzJFGU4ZCj_y2.4nMfn2.1toNdrxmgFv1ZSLfxCGUoBys6INtx2QvbK9KK imH2Up_HrN6BTwUYxcOJElyUKr.rg3WS.T4CY13inYBG.rkMbrbQKUT9nslBxQyxHvKRoyQtdkRe zr55PLjqXGACsbLkJvh_Ipb8XiWod7y65JyiSqabJB5tQ1HhWPcBIs.hGj9uVi8Hpu7.GA5pKBis f_zKGjW5m2SXj3Xn2gT4XiOk4NWCRPTtVTmxZ89hODlVhdGUBDHEgwJaahH_G6O9ouK2POQQiKad pNoniRMUvtAvMBRyrM8e_7hSjTUr0Uxug7SHA57CSDZeB6EH2RSfzi9sSBMCzuLhPXVm2NXH.cY1 xGNY8LmTcrfw_n2PTEuFbWQHHGp1SokO20fy_8w_THL3XNyp_4Mfga4wCzrdwr.q0fMJnzj1N5f8 MNhl1oN7YtGJj.5YIlD3OsM.n2DywdGaSPr.Ghuc0xzNMEvg.tge1i0l1AT76EdRfoozivYxFrZS QMNU_Mda1XgUc9MqTcqwF5aXWT81fVJcDbbO1r783wLLvnYNHXmlX9bl2ZxdH3Gk8Cdo8YlEs5FQ 6D25Q1k_TPglE8tn84jPVrL.TqnXS.zZOHrt.nq3hZh7zc2F4PUgbq0UOKXtm_7vbsZQI3.3QNT8 dDuQTNWYfn4RUS6JwZP9BDQjovibfRCvOqxVvlAjtkWFP34Nmr5sLL5XS6QhOofplBU.O2_JGwVa XsRtKhR4u8Jst2wm0TgnjnJfXC7iarFsuwfGwTcAxvWkNOy6NtHYxhmOQ2NRF5aTJJd95v4yimcr J.CFqA3tZx1bZM6Nwfc_c5yaZBzgbsKeDYkfX3m4L4WeTOouu49tW0fbA8yfw5NKMLgERn.DRlv1 LZt.bnbMojp2kLcUcgL23vC_XMrwKyyTQnrAA3Bn3ZX9hPm7KfPcRc86HnhX_Y3P4rh3nilHzd0_ i_MOC97_7LrprnL7mlaE2rBVedLmXoFEU_MqUIGhG9NKioMiEdf1OiCT9EEoHJqbLiq2s4hiBKVf E2iX73Zgf2Nf7nXjm2hb8WNctFW53GMga6gpmUMVAqkFFFXgZJNjUa9ZlXM.gmwIY_2MerdnEo3T turG2pHp7K6eXFwOxdCi2lZFsJmIumB_MqhC_FyUF7ZjzO9DowQpJvtxxnH35Gri7WyWlkE6j7b8 F65lnJghnIZSUp25fC.SujRY7dSvx4rUN7KnYFIZXLjzYSNcQ_UHNVnorz3Noun4DG4sXZRYRrle 4L88L_uDFt97MJHtsuRocOPguZNxS0l.v370zBx1URoyjfQ9W928VdPOjCv08bI6CQgDzudaIzFR ierplQOriJeKi4J0xf_wjOElJFYvy.epkA.H11O485_m7DVcO2psQH1cT336wodARw1unAAqDDyk 3HiwjjSykStOCyUXD6_57xZQY_KQbIIa4PYfPOxnnwPb9xbeErxAV.gEw2ntGJ9pq2vn1kk4P6Wd cbsVBsqjzTbGmcBYGz4631p_2NSnAfGYiC3RdsPyeWnDA_l3LZvxOct.lDqKE6dm0CmrZ5gX7ObH 8XjjTdis8rlJp6L.vSsV7MNDtOpsi4UTF8EVX1FecgOE8nqSQKioZM3SXAb1jW8OfQPwa93jlDYt AZfxBZXiNqT13wvfiF8.davYMtGw2qjspwt9KDF6ywKoLfFr5H9cKch0D3seOCvlnVfn8qnslHFX A_a94hqrO9D.Mb3Id1.Km1JuIPP0QVbK7SkkJ3qTjr_rOBiN9eYqRE9FIf2QmeMRensvVm_MHTMI Vljr_rdZwOz0L2DTHWCEZiagsIgCodP1l5nZMLyM_hEZmNws0iIzIlOLJZ8P..nl7jY2PBfquHv3 TUtYxYVpCUM9KlKNzumFFe9VGyPNXMC6M32zgn0RnR3kCb3jG31byVmOfndU- Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.ne1.yahoo.com with HTTP; Thu, 3 Dec 2020 20:00:16 +0000 Date: Thu, 3 Dec 2020 19:58:15 +0000 (UTC) From: Nagaraj Raj To: Pgsql Performance Message-ID: <815507272.4135293.1607025495638@mail.yahoo.com> Subject: Temporarily disable not null constraints MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4135292_429497216.1607025495637" References: <815507272.4135293.1607025495638.ref@mail.yahoo.com> X-Mailer: WebService/1.1.17111 YMailNorrin Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36 Content-Length: 3858 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_4135292_429497216.1607025495637 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, Can we disable not null constraints temporarily in the session-based transa= ction, like we disable FK constraints?=C2=A0 SETsession_replication_role =3D =E2=80=98replica=E2=80=99;=C2=A0alter table= table_name disable trigger user;=E2=80=9D above two options are working for unique constraints violation exception.= =C2=A0 Thanks,Rj ------=_Part_4135292_429497216.1607025495637 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Can we disable not nul= l constraints temporarily in the session-based transaction, like we disable= FK constraints? 

SET session_replication_role =3D =E2=80=98replica=E2=80=99; =
alter table table_name disable trigger user;=E2= =80=9D

above = two options are working for unique constraints violation exception. 

=
Thanks,
Rj
------=_Part_4135292_429497216.1607025495637--