thanks Jukka. all i am saying is: the DBMS enforces this restriction so it should be implemented when writing to it, not when creating a new layer from a resultset, possibly even from another DBMS.
..ede On 10.04.2013 15:55, Rahkonen Jukka wrote: > Hi, > > Just tried the following with PostgreSQL and table was created. I do not know > if it works with all versions and I agree that using spaces in table names is > not a brilliant idea. > > CREATE TABLE "test space" as select * from table limit 1; > > -Jukka- > > edgar.sol...@web.de wrote: > >> On 10.04.2013 13:41, Uwe Dalluege wrote: >>> Hi, >>> >>> Am 10.04.2013 11:27, schrieb edgar.sol...@web.de: >>>> On 10.04.2013 11:15, Uwe Dalluege wrote: >>>>> Hi, >>>>> >>>>> is it possible to change the >>>>> default Layer Name of >>>>> "Run Datastore Query" >>>>> to a valid SQL table name? >>>>> >>>>> An inexperienced user with SQL >>>>> maybe do not know that >>>>> "New Query Layer" is not a valid >>>>> layername (SQL-Tablename). >>>>> >>>> >>>> i'd rather suggest to check & hint so on trying to save the table so >>>> user can rename manually then. because 1. user has a learning effect >>>> then >>> >>> I do not think, that OJ should be a try and error GIS only for a >>> learning effect. >> >> how do you suppose a db user will learn about naming restrictions then? >> >>> >>> >>>> 2. the name is proper in OJ and not all db's have the same naming >>>> conventions >>> >>> >>> Please tell me a databasemanagementsystem which uses standard SQL and >>> accept blanks inside the tablename. >> >> why do you expect every DBMS connector to use ANSI SQL? there are >> several SQL dialects out there and used actively as well. >> MYSQL for one supports spaces in table names. >> >> ..ede >> >> ------------------------------------------------------------------------------ >> Precog is a next-generation analytics platform capable of advanced analytics >> on semi-structured data. The platform includes APIs for building apps and a >> phenomenal toolset for data science. Developers can use our toolset for >> easy data analysis & visualization. Get a free account! >> http://www2.precog.com/precogplatform/slashdotnewsletter >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ > Precog is a next-generation analytics platform capable of advanced > analytics on semi-structured data. The platform includes APIs for building > apps and a phenomenal toolset for data science. Developers can use > our toolset for easy data analysis & visualization. Get a free account! > http://www2.precog.com/precogplatform/slashdotnewsletter > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
