[postgis-users] QGIS SPIT import to POSTGIS -

Richard (Abe) Coughlin rac88 at hawaii.edu
Wed Jul 14 12:42:52 PDT 2010


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

    *PACIOOS - Pacific Islands Ocean Observing System*
    Sea Grant College Program / University of Hawaii
    1-808-956-0822 rac88 at 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<rac88 at hawaii.edu>  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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100714/03bf19fa/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: moz-screenshot-2.png
Type: image/png
Size: 25819 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100714/03bf19fa/attachment.png>

More information about the postgis-users mailing list