telosystools

Open full view…

can't generate from using postgreSQL that case sensitive tablename & column name

cheesang
Fri, 08 Jan 2016 23:47:37 GMT

Telosystools able to get table list however when click generate, it become lower case tablename due to postgreSQL by default using lower case, have to use quote (") in sql if want to be case sensitive. how can i fix this?

Telosys Team
Mon, 18 Jan 2016 09:13:09 GMT

Could you be more precise please ? We are using PostgreSQL very often and there's no problem with the code generated. When do you have to use quote (and why) ? Could you give us an example ?

cheesang
Thu, 28 Jan 2016 14:44:53 GMT

[1](//muut.com/u/telosystools/s1/:telosystools:ggiJ:1.png.jpg) [2](//muut.com/u/telosystools/s1/:telosystools:Gpcq:2.png.jpg) Hi, you may notice that in picture 1, the tool able to list the tables name correctly with Capital letter, when i click generate, picture 2 shown that the table name used become lower case and postgreSQL doesn't found the table hope these are enough to explain thanks

Telosys Team
Fri, 29 Jan 2016 17:58:24 GMT

Problem found. The SQL request without quote for the schema and table name is converted to lowercase by PostgreSQL. In your case PostgreSQL requires SELECT * FROM "public"."Agent" It has been fixed. It will be Ok in the upcoming version.

cheesang
Sun, 31 Jan 2016 04:25:48 GMT

cool. hope the next release will be ready soon

shamsulsaleh
Tue, 18 Oct 2016 08:06:45 GMT

i just install this plugin thru eclipse marketplace. Seems like is not fix. Is the latest fix was include in eclipse marketplace? please advice me how to solve this.