Hi, I noticed that your problem went away, but even if it works now I am not sure if everything is correct. Double quotes around table names should be a hint for a SQL interpreter that you want to use do called delimited identifiers and according to ANSI SQL for example in your case the most correct SQL select should be written as
SELECT ... FROM "toponimia".""lugares"" http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html I would say that you call for troubles by using double quotas in table names, even it is allowed. -Jukka Rahkonen- ________________________________ Hugo wrote: > Dear all, > I'm facing a strange problem that only happens on Linux. When trying to > publish postgis layers which name is encapsulated with " Geoserver gives no > error but is not able to publish the layer either. When checking the logs i > could find the following: > relation "toponimia.lugares" does not exist Where: SQL statement "SELECT has_table_privilege((SELECT usesysid FROM pg_user WHERE usename = session_user), 'toponimia.lugares', 'select')" > I could immediately find the problem. In PostgreSQL the table is named as > "lugares" and so, the previous query should be : > SELECT has_table_privilege((SELECT usesysid FROM pg_user WHERE usename = > session_user), 'toponimia."lugares"', 'select') > The stange thing is that I'm able to publish this layer when having geoserver > installed in a windows machine. Is there any configuration i need to do in > Linux to achieve the same result or is my only option to rename all tables? > Thanks in advance. Cheers -- Hugo Martins ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
