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 1u9XGm-0030rd-R8 for pgsql-general@arkaria.postgresql.org; Mon, 28 Apr 2025 22:48:13 +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 1u9XGk-003nua-JC for pgsql-general@arkaria.postgresql.org; Mon, 28 Apr 2025 22:48:11 +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 1u9XGk-003nuS-8X for pgsql-general@lists.postgresql.org; Mon, 28 Apr 2025 22:48:11 +0000 Received: from mail-pj1-x102d.google.com ([2607:f8b0:4864:20::102d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u9XGj-0004xT-0c for pgsql-general@lists.postgresql.org; Mon, 28 Apr 2025 22:48:10 +0000 Received: by mail-pj1-x102d.google.com with SMTP id 98e67ed59e1d1-3031354f134so4461140a91.3 for ; Mon, 28 Apr 2025 15:48:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wikimedia.org; s=google; t=1745880488; x=1746485288; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=NW2SK07crBW99aUhWWz5uClf/GD0qB2m+bnab767ShM=; b=NDXsif26uNoEy48is2p8QdFzd1ZP/julidjDm5daKvxGytjdtGYuwNVwwYHEQr0IX4 5SfVAPsfbPDzoGQYDlvq0EyVaVZ7IewnlH6MkZ3Ey4FF3swdQ7sAr3P00qaVyV1zxH9P 5jbibDyq1LLPNH2q/3bRz8RuidMGnf91APfY4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745880488; x=1746485288; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=NW2SK07crBW99aUhWWz5uClf/GD0qB2m+bnab767ShM=; b=gsNl2JjvVcSNrlO9Y5Yg1KA4s8I4rdJBfa3NE5DpUEbImxAX9q6ScdgEu79sw0ZpOO Ot5euhS6cfG/0exLW8EJKOcgsFbp1QBrINDFy+K3lQaQg09i2lKRV06342K8tYNK5k43 5V3Y4+TOXhEUIMapfDR5BaBWXTsA6sJyvjks/o6CyQy0Xs37WQ6qyloKwSPynmhC5w/Z /jVnS/xktuDCzdEutdoau/nCyillkFNT2Obby239Dqz7/SEC5AGr2Anz19WRf4s1oXK+ Vy3htE8cGldu1NC8rs38yfmNx/cYJIV1Qjrs09rAN/3GCeCXVRASPv3o/XdZaGz9d2qh mlKQ== X-Gm-Message-State: AOJu0Yzao4m+dEfu4k+miYsC7XTQ4rKopCYb5duOJkjfSXfI56htO6ZD 7xAjOSMdFg7eOll994AtPoDfaqHq9Nx6xrmO6ybmVENH6RMxbMqX4MiKdwJla3Q3KDQT/Sj6lrl EoX0= X-Gm-Gg: ASbGncvPtKp9dIA4uLmIBa6hBY7Kgw25f9CnYMwGSWdaT74zPlUjNDLDV4esYUIOmxu 9sU49fwbu6XUdiLMJne5kkcYz3VpvtAvoqAuqvzv2yIdWJ09xuYDIOC/azaj3xSU8sIJPlOvrWj zl/vMzfNhC/3WY2f2v2kYfuZpDzWjgVwbgU/VfJwrY4s+yGwMZqIVB+GxSvP6CAAp0CA3U8WXhm 470k1mJ42sWAqHdLssZ2FF966Px+ZErVHL+BWsr7dHx214R3hn3NcfPdEM52krMmzIyuXanf/Kl VSmqWU4AmeVQ4M8kF01dxE5T7lgePgMhjG17I7a2t5Uc9XvVDgB40dznb3TLzFAmv4wQpSoKAEf y6gY= X-Google-Smtp-Source: AGHT+IHIKxloS+RpeXmOnT6uvfjXeMhvhw/hCrjg9yn4/JAwaRiOWoGJjk8YbEtm1P7dCQhOqpwrhA== X-Received: by 2002:a17:90b:48c7:b0:301:98fc:9b2f with SMTP id 98e67ed59e1d1-30a21543866mr1976782a91.1.1745880488164; Mon, 28 Apr 2025 15:48:08 -0700 (PDT) Received: from [10.1.1.45] (124-168-128-17.dyn.iinet.net.au. [124.168.128.17]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-309ef099963sm9655333a91.29.2025.04.28.15.48.06 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 28 Apr 2025 15:48:07 -0700 (PDT) Message-ID: Date: Tue, 29 Apr 2025 08:48:03 +1000 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Upsert error "column reference is ambiguous" Content-Language: en-US To: Peter Geoghegan Cc: pgsql-general@lists.postgresql.org References: From: Tim Starling In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 28/4/25 23:30, Peter Geoghegan wrote: > You can use an alias for the target table name. Is it feasible to > require callers to prefix all field names with a generic table name > alias? No, primarily because MySQL does not support such an alias. -- Tim Starling