Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDtIx-0000cO-Pn for pgsql-sql@arkaria.postgresql.org; Fri, 27 Sep 2019 16:41:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iDtIv-0002D6-9H for pgsql-sql@arkaria.postgresql.org; Fri, 27 Sep 2019 16:41:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDtIu-0002Cz-VC for pgsql-sql@lists.postgresql.org; Fri, 27 Sep 2019 16:41:13 +0000 Received: from mail-pg1-x543.google.com ([2607:f8b0:4864:20::543]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDtIs-00052G-HD for pgsql-sql@lists.postgresql.org; Fri, 27 Sep 2019 16:41:12 +0000 Received: by mail-pg1-x543.google.com with SMTP id c17so3805019pgg.4 for ; Fri, 27 Sep 2019 09:41:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=LiXMPCfCc/l1Ok8GkyF3U1ht1FQ1/zcFouqnGc/X+5k=; b=JsE7VnEFIJaFwKyQWFIKzOGhvWMCqHuv18O3TcVP8c9A+0niqOSkIgyeNkZuHRKr2R pp04ERAKVCu89IrhAhMSK8X7X4nhzEnoeCOfLHoU1Z6s2cOjjnFWxPWCab8qdQzWTHGY t6ythMbIj20177FCdXz39lYBLDns8gRD9cG7NRRSFKjSK7tYMqCJ1e02hce300QzZj9k C6EKFIGU0dUX3gn5FCp59jz2s+4akMJGWPcH+v6UfsNXosRvYfrhsW5mN//HgAW+XP6e 7YqtavIhA2rNENeKfib0q/KdhNw8yB+C0Bcm48ggqheQhyqcWKbE9ZziZt29U+h5aUfk uGVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=LiXMPCfCc/l1Ok8GkyF3U1ht1FQ1/zcFouqnGc/X+5k=; b=tNWyZhjE89Yr1p6kIUaiYZgMuCrc7tXFj/i525Iw0zgeAkZYaU8ttgJ6GBUq7c0FW5 WgdbVgkc3Z5uq8XxWaWLb16dZkQ4q1Zl57JC/Dmev2keWMgEmfqzEsL6A1kQOPheIyvF BUtG046RYk3FtOZugA0E3iyF4ZnkJfz/VIrTi6LWWkfa5CzKzctsz9rjRViTSaQ6TMoY Txb/0EUdvTkaiqbohZDMle0DcSMPKdRymEgL2MGlDlcDYTFqrvBXzncr07QN0KZMBSFc 7jSdiMB0pZDz2w6iRFw+6U6Fw4EIyaFhH2h7IB3hw9q7BFpf1Z6tDXk3ZTscLJnT6ZMN IGpw== X-Gm-Message-State: APjAAAW18M8YWUkrO12+gRsBfYO678FzmhAafOikl7hoHRu11mnoX+gq SU1knOeR//9T+ouBjd8ciOWP41KjiGU= X-Google-Smtp-Source: APXvYqyicmSL07H1NcUJhiC7QbeTUvkH0N3ZURKWSNgDkt1YjTw/O5W2DGzxm3v43hlQv3WbDBQgQg== X-Received: by 2002:a62:cf82:: with SMTP id b124mr5309703pfg.159.1569602467218; Fri, 27 Sep 2019 09:41:07 -0700 (PDT) Received: from [10.104.134.41] ([155.100.47.1]) by smtp.gmail.com with ESMTPSA id x20sm4707120pfp.120.2019.09.27.09.41.06 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 27 Sep 2019 09:41:06 -0700 (PDT) Subject: Re: Transactions in one table To: pgsql-sql@lists.postgresql.org References: From: Rob Sargent Message-ID: Date: Fri, 27 Sep 2019 10:41:05 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 9/27/19 10:21 AM, JORGE MALDONADO wrote: > Hi, > > Does it make any sense to use transactions if only one DB operation is > performed in only one table? > For example, insert only one record in a "countries" table without > doing anything else in other table(s). One operation, one table, > that´s it. > > Best regards, > Jorge Maldonado When making changes interactively I highly recommend begin; ; like the number of affected rows; commit;