From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | INSERT doesn't like (<table>.<column>) |
Date: | 2000-10-09 13:23:03 |
Message-ID: | 200010091323.e99DN3N07872@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Adam Levine (adam_l_levine(at)hotmail(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
INSERT doesn't like (<table>.<column>)
Long Description
I'm using Dynamo connected to Postgres. The PreparedStatement generated for an INSERT works on other dbs, but Postgres complains with a parsing error.
specifically:
INSERT into <table> (<table>.<column>) VALUES (<value>);
it will, however, accept:
INSERT into <table> (<column>) VALUES (<value>);
I tested against SQL-Anywhere, just to make sure I wasn't losing my mind, and it takes either form.
This is using postgres 7.0.2.
----
output from postgres:
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
goe=> create table test (col1 varchar(20), col2 varchar(20));
CREATE
goe=> insert into test (test.col1, test.col2) VALUES ('test1', 'test2');
ERROR: parser: parse error at or near "."
goe=>
Sample Code
create table test (col1 varchar(20), col2 varchar(20));
insert into test (test.col1, test.col2) VALUES ('test1', 'test2');
No file was uploaded with this report
From | Date | Subject | |
---|---|---|---|
Next Message | VARGA, Peter | 2000-10-09 14:06:43 | |
Previous Message | Adam Levine | 2000-10-09 10:23:28 | Re: INSERT doesn't like (<table>.<column>) |