Cannot create index (not Primary Key nor UNIQUE) on postgresql

[ondras]

From tsamu...@gmail.com on October 28, 2011 11:34:20

What steps will reproduce the problem? 1. Create a table has some columns, then set its database type to postgreSQL.

1. Add index to the table, set its type to "INDEX".
2. Do "save" and create sql.

-- expected --
CREATE TABLE "sometable" (
col1 type1,
col2 type2
);
CREATE index "someindex" (col1);
-- actual output --
CREATE TABLE "sometable" (
col1 type1,
col2 type2,
KEY (col)
);

wwwsqldesigner 2.6 , Linux, Mac OS etc. , postgresql 9.0.6.

I think db/output.xsl might be incorrect.
I wrote experimental alternative code.
please refer attached file, that contains my change.

Attachment: pgsql-output-xsl.patch

Original issue: http://code.google.com/p/wwwsqldesigner/issues/detail?id=139

[ondras]

From ondrej.zara on October 29, 2011 11:22:53

Hi,

the postgresql datatype and XSL file is a contributed code. I personally have a very low experience with pgsql. Perhaps the "KEY(col)" syntax is for some older versions of postgresql? It would be nice to verify and confirm prior to replacing with your template...

[ondras]

From tsamu...@gmail.com on November 02, 2011 04:24:38

Thank you for a reply.

I cannot find such a syntax "CREATE TABLE .... , KEY(col [, col2 ...])" in any older version of pgsql. http://www.postgresql.org/docs/6.3/static/c0403.htm http://www.postgresql.org/docs/7.4/static/sql-createtable.html http://www.postgresql.org/docs/9.0/static/sql-createtable.html I send my XSL file, seems to be fine. I tested it with pgsql v9.0.1 .
Please test it among other contributors.

Regards.

Attachment: output.xsl

[ondras]

From ondrej.zara on November 15, 2011 00:11:30

Okay, I will apply your changes to the repository.