Re: Upsert error "column reference is ambiguous"

From: Tim Starling <tstarling(at)wikimedia(dot)org>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Upsert error "column reference is ambiguous"
Date: 2025-04-28 22:48:03
Message-ID: a72a16d9-07c6-4c9b-8758-e02232239429@wikimedia.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2025-04-28 22:58:42 Re: Upsert error "column reference is ambiguous"
Previous Message Tim Starling 2025-04-28 22:36:18 Re: Upsert error "column reference is ambiguous"