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 ) id 1umPy5-00FKG9-AS for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Aug 2025 04:53:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1umPy2-002wDj-P1 for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Aug 2025 04:53:34 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1umPy2-002wDb-BS for pgsql-bugs@lists.postgresql.org; Thu, 14 Aug 2025 04:53:34 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1umPy0-000TqT-0S for pgsql-bugs@lists.postgresql.org; Thu, 14 Aug 2025 04:53:33 +0000 Received: by mail-wm1-x32d.google.com with SMTP id 5b1f17b1804b1-45a1b097037so2544385e9.2 for ; Wed, 13 Aug 2025 21:53:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1755147209; x=1755752009; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=n9cA7rGZ5Ys+eLnN7kMdH+oWOjhX+hVSZj3b8zEhkhU=; b=V+tIh6+ipgQ/7RNitoUCn6raB2wnX0OzvuK0gYpAb94DO7OBjJtf1v+FgqRBVu9E5m w3jkGmLZJitmEmyKSKUw49/W9OZJHyvSTzvigWz6huYzsYxd8FuDJCQ/anZ646HOU5Xc WH4bDH42llZ7KKmap6UAOdPDT8JyHXtxt1NqxhilzdS4C5DaT5j4Q4UzbQW3O6oz4Wn0 9r5ipv49orXXmVxWwj2qbZlKKbsBzPr8IZAYM70sHZX77+VFOZJsVAOu14QS+M81Bu1a 8HVN06/u37GPXx8NTlZQE+WNheD6E8Sc3FonWgl/DvYMdF6nfxZNF3n23wBpapjS767q dKAg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755147209; x=1755752009; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=n9cA7rGZ5Ys+eLnN7kMdH+oWOjhX+hVSZj3b8zEhkhU=; b=qOn/eXuHFuo3CZxL/JCgWCk6xSPSZ2+mJd2clrrvGPQkBJ1SxU3dl548koZjtSH2nv 0KofPj5te3upCH+BrZFMlLsUSawFY9mdojJkOOOms8w1/YMm3VegvxwsiPhOCZJE1o/n X5RA4MZlnSiHCnyHKJSYCHTo1geiCo65M0jyptfy9wArYMSDIOOmTrEDCFT0A7t1O4fs 6fIuKEpwYl/wLQafpo5P8GtaZLdCWjCqv/1tiHuLND5OhkDBSK2szK/mG18n1yw4jENl GTUPqCV2glLFIouSAoo6RrqxPtT4EbBrnBD9bnjfYnQ7aCPeH0CM7MEKvVhR9P9f5b7b RkpQ== X-Forwarded-Encrypted: i=1; AJvYcCX7GO4CT004PXUZy6KmOy/ERlMRr/jIuXfdcEbwnqZM8WPrpgFZFcLd68QjbcXaoI6G5xynsHczpFOf@lists.postgresql.org X-Gm-Message-State: AOJu0YwOPeZUqHcbRns6sNo6n2Nh7I0OkIXRBOFl3cGgsPIzAoGrCzno +u+L2l2WvdySRy0GphhHniPQKR9Ed87sfF53J4dBviKY8QuczVEKXRvVfl2uB6zraFE= X-Gm-Gg: ASbGncunejd0U1BdrOhE9czej8/uyl2H3Jl2yyNkwrxQWioS5UDdsUVK1O9Ytokw+rm N9ckkmVstoUn7B6eDPXHkx6uBx6sL92DFLnn6xc3x+NVa/7Yv8xBGDZzhEFWperEZ87sHkyaeED u+eC2868zE2JOYMTg5+WChU0WWZwCPGHjr2NM9PoZPecBFDtcSuRz61MoUxR2W4G6RNM0m/pbW4 6vChB23age+wvWuDSecPmclEhTKTXDtnD8547Fz2l5xQIXS+TnKq/SnBuI2Mcyzw+hULK+feGW6 +AX9UkX+euTBl+V7BjmJxst9FQwm0h0idrQaG1I1wCVFETvFU49xfqCX2VJXqpDOeR4PyrmSXuh VXHIOm8LUwwabdMX8BUm+RtXPfFAcZBbflyeAK4FVTOGpDPC5h4Bb X-Google-Smtp-Source: AGHT+IF3+hLLIafaEv6lLyyS4tXiDfPJBDa6lqW3vyn//ObCpVYHHyklBXpahH5IDa8fFed7ErhtxQ== X-Received: by 2002:a05:600c:3151:b0:459:e3f8:92ec with SMTP id 5b1f17b1804b1-45a1b60e2e8mr10830185e9.10.1755147209162; Wed, 13 Aug 2025 21:53:29 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:d064:a5ca:9911:4d65:a3d9]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-45a1c6fcd32sm6190245e9.22.2025.08.13.21.53.28 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 13 Aug 2025 21:53:28 -0700 (PDT) Message-ID: <8950df651b0dbaee287bbd70dc057f696313d4d4.camel@cybertec.at> Subject: Re: BUG #19019: Feature Request: allow the use of column reference in DEFAULT expression From: Laurenz Albe To: spam@bit.bucket, pgsql-bugs@lists.postgresql.org Date: Thu, 14 Aug 2025 06:53:28 +0200 In-Reply-To: <19019-962b23dc13723881@postgresql.org> References: <19019-962b23dc13723881@postgresql.org> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2025-08-13 at 11:36 +0000, PG Bug reporting form wrote: > As it is possible in some other SQL RDBMS, it would be useful to allow th= e > use of column reference in DEFAULT expression. You can use a BEFORE INSERT trigger for that. If you allow columns in a DEFAULT expression, would that use the column val= ue from before or after the BEFORE triggers run? Yours, Laurenz Albe