Re: Column qualifier issue

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> said:

> "Jim Wilson" <jimw(at)kelcomaine(dot)com> writes:
> > As far as I can tell, there isn't a way to get postgresql to accept column
> > qualifiers (e.g. tablenames). A 'parse error at or near "."' gets returned.
>
> You're either very confused or using a *very* old version of Postgres.
>
> What version is it, what query are you issuing exactly, and what exactly
> is the error message? (Cut-and-paste from a psql session would be the
> best way to answer the last two ... or if the query is being issued from
> another application, you could turn on query logging and send in an
> excerpt from the postmaster log.)
>
> regards, tom lane
>

This is version 7.2.3, and the same error was produced on 7.4.x (using the
phpadmin demo site). Looking at the logs I don't see anything that is
addressing this. This syntax isn't required by sql92, but it is allowed (at
least that is my reading).

Following is a log from a psql session that demonstrates the problem.

Best,

Jim Wilson

bash$ ./bin/psql testdb
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

testdb=# select * from test;
cola | colb
------+------------
1 | Record One
2 | 2nd Record
(2 rows)

kelcodb=# \d test
Table "test"
Column | Type | Modifiers
--------+-----------------------+-----------
cola | bigint | not null
colb | character varying(10) | not null

testdb=# update test set test.colb = '2nd Record' where test.cola = 2;
ERROR: parser: parse error at or near "."
testdb=# update test set colb = '2nd Record' where cola = 2;
UPDATE 1