Re: [postgis-users] QGIS SPIT import to POSTGIS -
Luis, My original issue was that within SPIT it was not allowing the non-public schemas to be listed. It easily finds the shapefile and can create a table in the public folder but it wasn't 'seeing' the other schemas. Remember SPIT is about loading shapefiles to tables in POSTGIS, not loading layers. Richard (Abe) Coughlin OCEAN INFORMATION SYSTEMS SPECIALIST PACIOOS - Pacific Islands Ocean Observing System Sea Grant College Program / University of Hawaii 1-808-956-0822 ra...@hawaii.edu On 7/13/2010 10:47 PM, Luís de Sousa wrote: Hi again Abe, So SPIT needs CREATE privileges on the schema to load a postgis layer? Am I reading it correctly? It makes no sense... Luís On Tue, Jul 13, 2010 at 9:36 PM, rac88 wrote: Luis, Thanks for the reply. All the items you mentioned had been addressed. On further investigation I found the solution: QGIS SPIT calls the has_schema_privilege function via the script "select nspname from pg_namespace where has_schema_privilege(nspname, 'CREATE')". Note the second term 'CREATE'. The function has_schema_privilege(schema, privilege) queries whether the current user have the privilege for schema. For schemas, the CREATE privilege allows new objects to be created within the schema. QGIS SPIT did not show the additional schemas as the user had been granted the USAGE privilege only. For the user to create new tables in the schema the user has to have CREATE privileges or ALL privileges or be the owner of the schema (which gives the user ALL privileges). Thanks all for the consideration of my problem. Abe ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] quick ps/sql question on how to fill multipoint object best
Hi everyone, I'm sorry for the newbie question, but I am not very experienced with ps/sql (yet). I have values in one table (data just in numerical types, no spatial types) and I want to fill another table with them that contains several multipoint columns. I want a multipoint to contain around 300 points. I wonder how best to do that quickly in ps/sql. Many thanks, B. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] about dinamic segmentation in postgis
YOu might check out the Linear Referencing Functions available. http://postgis.refractions.net/docs/reference.html#Linear_Referencing George On Tue, Jul 13, 2010 at 8:58 PM, salas wrote: > Hi, > > I need to know like to implement the dynamic segmentation in postgis > > ¿ What tool can i use for prepare the polyline? > > and what are the step for this task? > thanks > > Salas > > > ___ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- George R. C. Silva Desenvolvimento em GIS http://blog.geoprocessamento.net ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Index on the Geometry Column and GEOMETRYCOLLECTION EMPTY
Sorin Dudui wrote: Hello Mark, Thank you for your answer. I have sent you at some data to reproduce the issue. I am wondering if you have received it. Best regards, Sorin Hi Sorin, Yes, I have received your email containing the test data. I shall attempt to look at this over the next few days. Many thanks, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 Sirius Labs: http://www.siriusit.co.uk/labs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] about dinamic segmentation in postgis
Hi, I need to know like to implement the dynamic segmentation in postgis ¿ What tool can i use for prepare the polyline? and what are the step for this task? thanks Salas ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] QGIS SPIT import to POSTGIS -
Hi again Abe, So SPIT needs CREATE privileges on the schema to load a postgis layer? Am I reading it correctly? It makes no sense... Luís On Tue, Jul 13, 2010 at 9:36 PM, rac88 wrote: > > Luis, > > Thanks for the reply. > > All the items you mentioned had been addressed. > > On further investigation I found the solution: > > QGIS SPIT calls the has_schema_privilege function via the script "select > nspname from pg_namespace where has_schema_privilege(nspname, 'CREATE')". > Note the second term 'CREATE'. > > The function has_schema_privilege(schema, privilege) queries whether the > current user have the privilege for schema. > > For schemas, the CREATE privilege allows new objects to be created within > the schema. > > QGIS SPIT did not show the additional schemas as the user had been granted > the USAGE privilege only. For the user to create new tables in the schema > the user has to have CREATE privileges or ALL privileges or be the owner of > the schema (which gives the user ALL privileges). > > Thanks all for the consideration of my problem. > > Abe > ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
