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 1kceJP-0003ba-6Z for psycopg@arkaria.postgresql.org; Wed, 11 Nov 2020 00:48:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kceJO-0001Ps-0f for psycopg@arkaria.postgresql.org; Wed, 11 Nov 2020 00:48:34 +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 1kceJN-0001Pl-Pf for psycopg@lists.postgresql.org; Wed, 11 Nov 2020 00:48:33 +0000 Received: from mail-lf1-x130.google.com ([2a00:1450:4864:20::130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kceJL-0005Hl-B9 for psycopg@postgresql.org; Wed, 11 Nov 2020 00:48:32 +0000 Received: by mail-lf1-x130.google.com with SMTP id r9so775466lfn.11 for ; Tue, 10 Nov 2020 16:48:30 -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=1gaMQu3O/P97O07iQfyoMiccCW51NXZbjRXeorpOLIw=; b=kdznd4xpqb5+y21gr4+tf83XJtok1DrOX1D9wTFL9C8mkEBsqBlPNrneDoIVYg22FD hXhVDCdxvM5rlEiFKHXB6f4VoIAFmIfOBLTtKlekDFPmVO4npF30vM0QpG915CGbJ5nx EisfVLlZK8nJMPBGo+Ls0y9NvkzZgGEMXa/ljP6Z+eo1zjbdnlGcZSZArMu+B9ZktLuB G2bxziXLmWcb8m6buB1U1uNstrWoTkdoAXC6nPYe6n09Tjx5YzFe+PQtfkhQ0v0NOoUC h9hT1k/Aq+9rsw3Pr/+gtUG6h19azZLTxRG7bdeyU/W59Fah2W7NY5VB8RfgulfXzJ4f Oyqw== 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=1gaMQu3O/P97O07iQfyoMiccCW51NXZbjRXeorpOLIw=; b=k8+KMYGpjACH6cPzLLHx7gW9v8JZSCuNOJVDjBr30YQSHpmAMLG9QFOidQjwInF1aI eBlCA6VMN3hZYkmNiZ5dyal/uxQp67CANh1srgb7ODsNDT3p7VKY3U9kIhjEVeDMt0Hs uV67JspwNxKFsiUy97cQZ7w8M7xAW+FbMBYwnvMHM8j0wB3qm6gzHfwyuJoJZbsAGJ5A PylruBGTvpZPYe7+chIVIXhnbV0E21OIIQPGRUSQAFjXvLkgCo8FbuH1fHe0EyhQpHsc ZsDRVASr+IOnoxEaBewQN0Gvq9xlGXmUyLsg9cvkJYvwbSA8qhY9w3eMdw0duCqKM+5V nLPw== X-Gm-Message-State: AOAM531YjjPBzW+cWrdTRplNXQiTV+KYqa+E3h4t+cipOlNmTQKDrMkg T84l599dn9ETbGrtBkaGBugDjMje4BI97tCi4KI= X-Google-Smtp-Source: ABdhPJzL1VIpyi6V91bp5uhIDftTKQkiJCl1/GZUwwGBwtvH9v1KnDqcR6xhB9nRIq5lTfW9turk2F8pN4/CpsKWJnk= X-Received: by 2002:a05:6512:3711:: with SMTP id z17mr2994142lfr.350.1605055709019; Tue, 10 Nov 2020 16:48:29 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Daniele Varrazzo Date: Wed, 11 Nov 2020 00:48:17 +0000 Message-ID: Subject: Re: Using composite types in psycopg3 To: Vladimir Ryabtsev 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, 11 Nov 2020 at 00:36, Vladimir Ryabtsev wrote: > > Awesome, thanks. > > It would be great if it worked out of the box, as in other drivers. I do agree. I have much more experience with the text format, and in my understanding not all the types support binary I/O. But my understanding could be wrong. After covering the binary format for the missing types (especially numeric and date/time objects) we can probably do more testing and check if defaulting to the binary format doesn't have unexpected consequences. Cheers! -- Daniele