Skip site navigation (1) Skip section navigation (2)

BUG #1540: Enhancement request: 'ambiguous' column reference in psql

From: "Richard Neill" <postgresql(at)richardneill(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1540: Enhancement request: 'ambiguous' column reference in psql
Date: 2005-03-13 07:51:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1540
Logged by:          Richard Neill
Email address:      postgresql(at)richardneill(dot)org
PostgreSQL version: 8.01
Operating system:   Linux
Description:        Enhancement request: 'ambiguous' column reference in

Dear Postgresql team,

I have a small suggestion, which isn't quite a bug, but where psql throws an
error which it could in principle recover from. These occur when a column
reference is ambiguous, but isn't really, because of information supplied in
the join.

Here is an example, which I just tested in 8.01.

These are the database tables:
	instrument	character varying
	priceband	smallint

	priceband	smallint
	pounds		double precision

This query fails:
SELECT instrument,priceband,pounds FROM tbl_instruments,tbl_prices WHERE

ERROR:  column reference "priceband" is ambiguous

This query succeeds:
SELECT instrument,tbl_instruments.priceband,pounds FROM
tbl_instruments,tbl_prices WHERE

I think that the first query ought to succeed, since although priceband is
ambiguous (it could mean either tbl_prices.priceband or
tbl_instruments.priceband), the information in the WHERE clause means that
they are explicitly equal, and so it doesn't matter which one we use.

Thank you very much for all your work - Postgresql is really useful to me.



pgsql-bugs by date

Next:From: John EngelhartDate: 2005-03-13 23:13:49
Subject: BUG #1541: Unusually long INSERT times after fresh clean/CREATE TABLES
Previous:From: Bruce MomjianDate: 2005-03-12 21:30:12
Subject: Re: ALTER DATABASE ... RENAME: permission denied for superuser

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group