search

neojjang / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

Postgresql SQL generation error #13

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Generate SQL code for Postgresql using tables having foreign keys

What is the expected output? What do you see instead?
We get:
<< ALTER TABLE "table" ADD FOREIGN KEY (columnName) REFERENCES "table2"
("columnNameID"); >>
but should be:
<< ALTER TABLE "table" ADD FOREIGN KEY ("columnName") REFERENCES "table2"
("columnNameID"); >>
Quotes are missing at foreign key column.
What version of the product are you using? On what operating system?
version 2.3.2

Please provide any additional information below.
This will not be of any issue to anyone naming their columns in lowercase only.

Original issue reported on code.google.com by i...@amarosia.com on 19 Apr 2009 at 11:57

GoogleCodeExporter commented 9 years ago 
Should be fixed in rev. 37.

Original comment by ondrej.zara on 20 Apr 2009 at 6:39