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.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sMbvh-003K9a-1b
	for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Jun 2024 23:19:57 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1sMbvf-006x67-ER
	for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Jun 2024 23:19:55 +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.94.2)
	(envelope-from <dgrowleyml@gmail.com>)
	id 1sMbvf-006x5z-53
	for pgsql-hackers@lists.postgresql.org; Wed, 26 Jun 2024 23:19:55 +0000
Received: from mail-lf1-x130.google.com ([2a00:1450:4864:20::130])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <dgrowleyml@gmail.com>)
	id 1sMbvd-003j1W-DW
	for pgsql-hackers@postgresql.org; Wed, 26 Jun 2024 23:19:54 +0000
Received: by mail-lf1-x130.google.com with SMTP id 2adb3069b0e04-52cdf2c7454so8995821e87.1
        for <pgsql-hackers@postgresql.org>; Wed, 26 Jun 2024 16:19:53 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1719443992; x=1720048792; darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=an6xoX7fETMvz68lDtbGmGu/xjYqaW+yJxjHqgv3AHQ=;
        b=hs9shYz3NbDCMXT4SWc8K6kgPgSL6eI0tYu9/M5gKY16GXwgtjxIH2JROgeaixuV+O
         m8XYGAUWzbdA64jbc2A6e5zMvR5eaYU1BRz9gQCme7vba07nij8A1uSBR/aNcO34PDEB
         LkbDeFDlS+mRX9DZWSoyrj300B+fckmcyP7MAJTtXB6VNVulFdxvkmlGg4UqWUXLYNh+
         hT68vFmrZBhOcu9TgAtHDwy08UaYrjdN2mw0AVsvqhAWHmKg+UMu4Hue8jfrZhJMnU46
         8f1TVq+SGnmvY1gsN4ZuVI/SKGHq8GKWB+ed/PH5ynl6Qx0EWnH13aaNgvp+kkiBJxOZ
         37oQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1719443992; x=1720048792;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=an6xoX7fETMvz68lDtbGmGu/xjYqaW+yJxjHqgv3AHQ=;
        b=HTkHaplWLzyek72MsJF7IMcccUZ0nHLj2xuFOEpFt9z+5ef+uppJHjA/sfV9C9Mikv
         nG5fR7hs6Medj2DM7Mt3J3RmkUQKn+iVJjy46orDP8OyfpJ96PloYxF0btoCtR+Rny7J
         dX8YjzzXz7bZTroFz33D2ogiQ5hWK5x1jLhPfPqlbUvdQuVQ3f77QG24gFgCl+sPZEHs
         OL2DQKQTVmjQ3ZVP0wed2NQZk4E7MOsLNQuVgd0i1Qu16Pk/UNpbIpLq1OhGjTM8Xxw3
         U/PufWWkdzZj6VkqHsDX06LSEm/gicQYikQ9NDCRqZq/fQEDDk75vmoWAw+Rs7H1dFGK
         uSSw==
X-Forwarded-Encrypted: i=1; AJvYcCXWq6rqMze3Z9WXeovwlhjllX2EvX2NsVbFrzxtXfUaXFoWh15nuCsZPbHxwVjVftXGsohxpzV+pVnP97xqqcERzHmgubiE16n7iRdJ
X-Gm-Message-State: AOJu0Yx0KDnJjVH9GWoUNtaUii5jPhJARgs3kLbT4iJeuwimzDaNfDym
	DCMAv60E+WvVBTpE2hIm/HtDCm5Kj52iNiwz+z1T7PEBKI60NAftwTJWLQJ2NEqYTIy0r/mQnYt
	2Uu+9lfuY89P5fwDLsjsKiJknDS0=
X-Google-Smtp-Source: AGHT+IGSt6H/WgR+NqKyRmSxVtuFitZLjdjbAvOJCJs6hLrnNym7iAyt/4vh7w87VhzRBoMxhGlXcCQeLC8S9N0kfZA=
X-Received: by 2002:ac2:41c5:0:b0:52c:e17c:cd7b with SMTP id
 2adb3069b0e04-52ce1832abdmr8968562e87.22.1719443991946; Wed, 26 Jun 2024
 16:19:51 -0700 (PDT)
MIME-Version: 1.0
References: <CAAaqYe-wQPbchCUE7pocPNEQ3PMY8a98Txmxc7q0+FvXtk1vvg@mail.gmail.com>
 <1362410.1719349169@sss.pgh.pa.us> <CAAaqYe9_RE2WximHuYRpyfU-H2G+W--49e_8GDqS-vHLOzPvmg@mail.gmail.com>
 <1390099.1719357084@sss.pgh.pa.us> <CAKFQuwZkgm0yqHhf05thqu1gzUK__gXBL5tyBuFvKoOe7Dd6=A@mail.gmail.com>
 <CAApHDvoiHYxM2VQYZeiF7JAdP7Y0JxEr86NZpUjoZ9AA4cpzYw@mail.gmail.com> <1437009.1719378777@sss.pgh.pa.us>
In-Reply-To: <1437009.1719378777@sss.pgh.pa.us>
From: David Rowley <dgrowleyml@gmail.com>
Date: Thu, 27 Jun 2024 11:19:38 +1200
Message-ID: <CAApHDvo4z0pU81cfVZTTqWk28oT3rgswtV2nKzSHwDQ=P5aZ=w@mail.gmail.com>
Subject: Re: Should we document how column DEFAULT expressions work?
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, James Coleman <jtc331@gmail.com>, 
	pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/CAApHDvo4z0pU81cfVZTTqWk28oT3rgswtV2nKzSHwDQ%3DP5aZ%3Dw%40mail.gmail.com>
Precedence: bulk

On Wed, 26 Jun 2024 at 17:12, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Do we want to do anything about
> nextval()?  I guess if you hold your head at the correct
> angle, that's also a magic-input-value issue, in the sense
> that the question is when does regclass input get resolved.

I think I'm not understanding what's special about that.  Aren't
'now'::timestamp and 'seq_name'::regclass are just casts that are
evaluated during parse time in transformExpr()?

David