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 1nUapX-0001dA-Jp for pgsql-sql@arkaria.postgresql.org; Wed, 16 Mar 2022 21:05:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nUaoY-0003fs-HI for pgsql-sql@arkaria.postgresql.org; Wed, 16 Mar 2022 21:04:14 +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 1nUaoY-0003fi-7J for pgsql-sql@lists.postgresql.org; Wed, 16 Mar 2022 21:04:14 +0000 Received: from mail-pl1-x62a.google.com ([2607:f8b0:4864:20::62a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nUaoP-0001EX-NW for pgsql-sql@lists.postgresql.org; Wed, 16 Mar 2022 21:04:13 +0000 Received: by mail-pl1-x62a.google.com with SMTP id q13so2778628plk.12 for ; Wed, 16 Mar 2022 14:04:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=1KfkwHCxU2+X+PYwxtPDQv+XdwjB41p33N1F2Djb51s=; b=Xc+GG6Z6tTyDuIoNwvHM+PvTMlY81/kms5M8kCp1aLUvSs+L3oTls4+aOKZRx5n9+r zOcEnsal74RSbK4BVr9d0mDAn0oWqZZvi4YQbVei3gNDGE7Ty+ejkEFeoL0i/+o8RubY vj/fAJfX05pWjAWiAI9f7ytDX/ApUY15kBTWdBGlcSPV6X7Zseg5sJeSt+ZNIU7SDK3l 8y/RYmdoa9S8BnZbghKbc0a2DQHw0+I8apJhLF3hlp1djktZV2NmyNTkYj8HzzJwAQv6 BPkw+RJx+J2ptyWAb6DBRpDZN9xqsBdDxT6OWIHJbiZRAqQ0pYNR2frGDQMP14LdHnVS waBg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=1KfkwHCxU2+X+PYwxtPDQv+XdwjB41p33N1F2Djb51s=; b=4ci+6O7a34PiOizFDx03sCPqDXHMJb7plX3yCPUjN50SQnVGN03wbABqtGcH/Do6Us 8+ujGSY1QTevyQW2zvybROu6iLMGon1RLz8IRkF3iI8T3I1pjyHe1cXJTIKzP2KimLpC l5wPiktXSNKmCG7GXbx7/2LFtXhSzKoYD0q/LHVdpuyj4djRXgXeKRd40Qfr/esCfO5V dVHs2iUftr8+Iu4F4TGAgwPPmsYqQ1FvPpEgKg+ItQu09L+TKt3mrY23yQ4Mt5Nlj4d5 ffdeadhvO6U6NWjtAbLjTgzk1d+mBb7LO0Hw+JrEL6MJxuUUrq+GAU9Iuo5MOqoP+NZK tPkQ== X-Gm-Message-State: AOAM5310Fubqg3YlZx22q2gqKsRMqU96Lv3/V4mdGbgP6tJpnKYhfUQt JrV/cT7wSY2aGwt10ch0MzQ= X-Google-Smtp-Source: ABdhPJzRhIpJ4POLcF2HD60sTqcPAH/E9qDEbz9pVlOLXB04Lg9V+xCRxfxsEmwamC/lYTCHDkJddA== X-Received: by 2002:a17:902:c946:b0:152:1c9:d12d with SMTP id i6-20020a170902c94600b0015201c9d12dmr1271007pla.145.1647464644630; Wed, 16 Mar 2022 14:04:04 -0700 (PDT) Received: from smtpclient.apple ([2601:681:5500:dde0:50b6:32a7:7c2f:614]) by smtp.gmail.com with ESMTPSA id b16-20020a056a00115000b004f6ff260c9esm4232896pfm.207.2022.03.16.14.04.03 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 16 Mar 2022 14:04:04 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.120.0.1.13\)) Subject: Re: How to explicitly state unlock in sql? From: Rob Sargent In-Reply-To: Date: Wed, 16 Mar 2022 15:03:59 -0600 Cc: pgsql-sql Content-Transfer-Encoding: quoted-printable Message-Id: <0844F95A-200A-4AF7-B04B-0E143264E2D8@gmail.com> References: To: Shaozhong SHI X-Mailer: Apple Mail (2.3654.120.0.1.13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Mar 16, 2022, at 2:56 PM, Shaozhong SHI = wrote: >=20 > Locked tables stop progress. >=20 > How to explicitly preventing locking? >=20 > Regards, >=20 > David It=E2=80=99s much more likely that your workflow needs to be = altered/corrected. Of course you haven=E2=80=99t explained any of what = it is you=E2=80=99re doing and what exactly are the symptoms. I would be curious to know your mental model of how this email list = works.