Tom Lane <tgl@sss.pgh.pa.us> said:
> "Jim Wilson" <jimw@kelcomaine.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
