SPIT: Schemas not owned by DB-role cannot be accessed

[best]

When importing shapesfiles with SPIT the user may choose the schema to write the new relation to from a drop-down list. However this list contains only schemas owned by the logged-in database-role.

If the schema is owned by a group role where the logged-in role is a member of it is not listed.
If the logged-in user has create rights on the schema it is not listed either.

To reproduce follow these steps:

1. create a schema as role A
   
2. grant create rights to this schema to role B
   
3. start SPIT and log in at the DB as role B
   
4. choose the shape file and see the combo box in column "schema"

Tested with 1.0.1 on WinXP and 1.1.0 on Linux (SUSE 11.1) so I reckon all platforms and versions are affected.

[lutra]

Hi,

have you tested the postgis manager plugin?

I guess that SPIT is not being developed any more and that postgis manager is the new reference plugin for interacting with postgis.

[jef]

fixed in r11514

[best]

@lutra: tested PostGIS Manager this morning, however my users prefer no-overhead plugins :)

@jef: Thanks for fixing!