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 1kkUH2-0008S6-EV for psycopg@arkaria.postgresql.org; Wed, 02 Dec 2020 15:42:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kkUH1-0005dm-1a for psycopg@arkaria.postgresql.org; Wed, 02 Dec 2020 15:42:31 +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 1kkUH0-0005df-OV for psycopg@lists.postgresql.org; Wed, 02 Dec 2020 15:42:30 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kkUGv-0002Q5-Iv for psycopg@postgresql.org; Wed, 02 Dec 2020 15:42:29 +0000 Received: by mail-lf1-x12c.google.com with SMTP id l11so5510841lfg.0 for ; Wed, 02 Dec 2020 07:42:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=QwNi6VB0Y6inb8Z2rOCJZRAlyJ8yAQ3l0W6+IfKW3Wk=; b=vSn//ut5eMXDSEr5vZ8YIbrl/G+Vr6jyISauinYFphW2/nqFj4fc5dIiO3iX3XvvWZ 8PJ7MiWdmvVxgVZ0nzYa//nxUPK+7h7pBTkHzFrvR68thVsX7kxFnUXnGYI3DdcqMNOq eCXpnf5djy88YiD1YPpkH9uMa+3iHPI+OPtNjQrgBKcEXZLcpR2bMaw6KkbJHf+fz024 uNqrCtjI+ydOllAllvF0zR2dL9CPuxMBD+Pd1g6/G5/0Nv7qx5A08wwxZlZRIasyDAC1 x7fu1qtXeYZBNfAEONjOKDPLNYRPNXtZT2yZq2sgFD40/rVB/0YqcS2cFoxhll4G/1+X 1DkA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=QwNi6VB0Y6inb8Z2rOCJZRAlyJ8yAQ3l0W6+IfKW3Wk=; b=sWI6Dp1zvO0MT4NXHL62ZKXlauNf/jeK35k/v742muPG1GNZ6YPPxX4UVbZXzsoGZY vrXAcIGcV2rtVEzOiTmm6d2LMAgsnWHe2m5M77nE7C+xbq1naKEipMcWzUbqj+3x1Mf+ xutHupOZgqPLqe/ykhZvkKBsHpq8wlBbvgq4Tj7yljIsSVgioYlU4gnCXT+XTbkCV2BD C14B3dTHQ0UyKk/U+jVc1zUSrDt8gicUiJJBQnG9/PCwgVDmg4swY0oeMbvCSpFNdVQS vWseCayt3EGZZJD82RadvXWhzmCqvfVddu8duSW8h8Fipg2IJa+duUKwMCVtLUa+xCiz ZLuA== X-Gm-Message-State: AOAM533wNvS4b8EsArpNONr3Ctcxv4Uo4CqpQ7AeEmM7vwMqPbItxKVU baiNQZEQ3t6enrrxIDUZoXw8PqX+blcxSLtORyfaETwn X-Google-Smtp-Source: ABdhPJzqS+pC/nEwxjZDbA5ypL3coe3t47GGmUQuXztKoP5o163V/gvxx8mJM4p2vzS1aAIQxWDcTV7nHZ/JTDODGWI= X-Received: by 2002:a19:6416:: with SMTP id y22mr1536123lfb.555.1606923744058; Wed, 02 Dec 2020 07:42:24 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Daniele Varrazzo Date: Wed, 2 Dec 2020 15:42:12 +0000 Message-ID: Subject: Re: Executing on the connection? To: Adrian Klaver Cc: psycopg@postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Wed, 2 Dec 2020 at 15:02, Adrian Klaver wrote: > Just to be clear the above(callproc excepted) or some variation of it > will still be available off the cursor interface, correct? Yes, that's correct. The cursor remains with the methods it is known for. This Connection.execute() would only be the moral equivalent of: class Connection: def execute(self, query, params=None): cur = self.cursor() cur.execute(query, params) return cur but nothing would be removed from the cursor interface. -- Daniele