[BUGS] INSERT doesn't like (<table>.<column>)

Adam Levine ([EMAIL PROTECTED]) 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
Reply via email to
