Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vwwEO-005IQ7-0y for pgsql-bugs@arkaria.postgresql.org; Mon, 02 Mar 2026 05:54:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vwwEN-00Fbep-0k for pgsql-bugs@arkaria.postgresql.org; Mon, 02 Mar 2026 05:54:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vwwEM-00Fbeg-39 for pgsql-bugs@lists.postgresql.org; Mon, 02 Mar 2026 05:54:10 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vwwEJ-00000001yjL-465i for pgsql-bugs@lists.postgresql.org; Mon, 02 Mar 2026 05:54:10 +0000 Received: by mail-ot1-x32c.google.com with SMTP id 46e09a7af769-7d4c3896e32so2210798a34.0 for ; Sun, 01 Mar 2026 21:54:08 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772430847; cv=none; d=google.com; s=arc-20240605; b=AYQ1AnSkBbk9VKI7TO4RyYeYnngu3ice747vM5yRyrZ5LA8RcT12o/eoECoER+dYsO RL0d0lzoLZjOeFQ1Fv8z7TPFjs97QPq23SbpuqWAlfZtmxQ0QakcUHucfNVibwK+sQy/ mLEjZRekYTBcuhPHyUkGmgNRtIyNkQGA/G2s/S9oib13AEqdX9R53/Z6eKpX76t06C4D zUWwCyO/1Z6PqvhlOqss5MDb3Ak9XcZydb9nx8ktYeZQA137nJl2rHdo3CNvVxHQ/NSS d6AaKAluZ6/AwtezpNzL3Vdi2DkLmA6vxWNfpRyf7BfIRXO6sRqSFy6gZ5OtmOzjmvxF /iVw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=asUwMQz617iC2FxgvZ6jGgL2kN+RaAMAB7hyVdC1GZg=; fh=cjSkri5kPhD2rUvREZvkTKP3vbVBcoGzKrNbo0jt0og=; b=ItGAf2/k6T2cAv9OW+54gi8DNAS8H/02eBB2Ksgc5QhMxRv9FJSg/En0ws6pXh6rWq 4w4fMgKGOukc1GrVgoS04Es0ICSBXLGTOAo6TMAayLSmSKdUNeugKEiYGdq5IpnF1Tvq hXJUXZE8UD0Vq2DqmaI3RUZ/+08MK2UM4a6R1sAtiBVU7JYzpcXkO8z+vab5/FpTnI3X mJdoJli2cCNQYN4KRGVV6DpfE7A2WU1LzdM8yiEpPpwL+IH4DE3ZWLLMKlpVz8HHeZey BFeeKM4eb3gEnxYg9rlVV8lCpMr5h0Ss7LPbSl9u8prgYVxOk3tsEcSuU2WdD/6rSdNe MC6Q==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1772430847; x=1773035647; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=asUwMQz617iC2FxgvZ6jGgL2kN+RaAMAB7hyVdC1GZg=; b=JwdgNrAiHWd3947l0xamDW6Ejk7T+RJNAYaVkuRzqUt/Nx9pihYsKpR4gLEd2MBe1a L2LxT3xk3jD/mVw4aAssTD7qNqrbbNkvbOKvcUwyJVrlmcLgv3xaSD8pnY243iMRE5UV P7d5GHtK/Rb7SHGW+gyjs+iL3zAxYhkuGcwemD+pJFCtnlM8cWyec8sXT6QOuI+aEAeo NLYp25VcMGOY22L/AoaXlIbdOoWKZXbm+NOVOAAqe4Mp4UsDU8pULtIz4KVQRWNGCPC9 gGPNfV3vb8RL5J7WfwaTIm+PMjWF2Obs2J5+FdUNR87caK6SLl3r8b4lhyZBkVtQhYke 1/JQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772430847; x=1773035647; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=asUwMQz617iC2FxgvZ6jGgL2kN+RaAMAB7hyVdC1GZg=; b=YGaisnlYtg3MkxkBPVaSSpccVF1AwjIIssFrJJPcdqvtq59+UKa2OLL4C3yIDkNZwF 5m7Lsx0jy8kQtsvje/yRdyJ+CZ6SOLjmcvuy82NWnWptJL5OJgJ0IcZVrdP2ORosIbjY FAngEFWb05C6SYb85C/E8nEg67hOwndvm527sxmEi/YhlMxg9UXA1hm0qBPTIsx/UBqw Wvv53Mc/nCW9cC/CEzAfZPDt/LaCSIIx2BClkXZ469NIUmMTkr7ZUO5OZ00/DTrfopYw uc3TUc//RAXts4dZ1aWYKE+1xhi+L+ndiHLOJMcBM8ajw9eBrpDWtoiZ/Y5jIuh2/x9e D2pQ== X-Forwarded-Encrypted: i=1; AJvYcCUsEHCDySCLYbX7Z0QLkc/gtXLm8985TJV14qLJmeMyMFK+y80YXsBAQCJdK7d/4fgHC7Mfz3tPpuly@lists.postgresql.org X-Gm-Message-State: AOJu0Yzq354kySq3UR+iwGUGQWRDDtOzGx0+0+K36EME9uzko7TbL2vc CZCQvxHFIO9ilcH4OadFxmemoJzxv7wz0HJZs1rueoSomZ1x6HkYkaB1AocNOskVQePNpC8KuPY xQm+c3+mMkmK0BrFaIU1ZcE6B0ZpIWc4= X-Gm-Gg: ATEYQzynr3u4XG7Yvope3zfNeHYHcoKwNOgVerohmpaFcrmPuDiZpcktanCQsTJ7XD8 6HwL2i+k4l3xW5KG3IKwGT5irGOZCC7UJE0Mz0ImkrhubnccTqSUcdv4cl1ybQFbGSrgtApMTql LnMbq7CI1giSAarQXu/IQA5vZm0FFdX45Xa1o6e8H7UFcfw4qvWI+kGUq1IT4mvb+6DRDhmBQEL NWpN/iB56YHW/f0+KTudkISkhrkSgM5ywI0/TVFVGFFYVbFcSMMhiWRxOOKY3KjEl1YMm+RWGzv 3UYD4v5DQA== X-Received: by 2002:a05:6830:67fb:b0:7c7:da3:ed22 with SMTP id 46e09a7af769-7d591c17e7emr9032077a34.32.1772430846730; Sun, 01 Mar 2026 21:54:06 -0800 (PST) MIME-Version: 1.0 References: <643857.1772122240@sss.pgh.pa.us> <717830.1772130430@sss.pgh.pa.us> <852982.1772205703@sss.pgh.pa.us> <988126.1772215716@sss.pgh.pa.us> In-Reply-To: <988126.1772215716@sss.pgh.pa.us> From: Richard Guo Date: Mon, 2 Mar 2026 14:53:55 +0900 X-Gm-Features: AaiRm52nGfMzZ8quf-dE7J_q7c6hxFVButW4L6aysgR7BZQ5aNtl30geBp6LN4o Message-ID: Subject: Re: pg_get_viewdef() produces non-round-trippable SQL for views with USING join on mismatched integer types To: Tom Lane Cc: Swirl Smog Dowry , pgsql-bugs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Feb 28, 2026 at 3:08=E2=80=AFAM Tom Lane wrote: > So I went ahead and pushed this, using your test case. Thank you for handling this, Tom. - Richard