[Qgis-user] Primary key and spatial index

[Richard Duivenvoorde]

And in addition of Chris's answer:

The user you connect with, should have enough permissions to create or update an index.

If not, QGIS (or yourself via psql or another client) will also not be able to create the index/pk.
In that case you need to rise the permissions of your user, OR use another user to create it.

QGIS should NOT crash though.
If THAT is the case, please file a bug in our QGIS' tracker (with a reproducable scenario).

Regards,

Richard Duivenvoorde

PS which QGIS version are you using here? I cannot get this message visible (but I do not have large tables at hand currently)...


On 2/16/24 06:56, chris hermansen via QGIS-User wrote:
> Rikesh and list,
> 
> On Thu, Feb 15, 2024, 18:40 Rikesh Lad via QGIS-User <qgis-user at lists.osgeo.org <mailto:qgis-user at lists.osgeo.org>> wrote:
> 
>     Hello,
> 
>     Please see attached. Does anyone know how to add a primary key and spatial index to a large layer without the software crashing?
> 
>     image.png
> 
> 
> 
> Here is some reference info about adding a primary key to a PostgreSQL table
> 
> https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-primary-key/#:~:text=To%20add%20a%20primary%20key%20to%20an%20existing%20table%2C%20you,to%20the%20primary%20key%20constraint <https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-primary-key/#:~:text=To%20add%20a%20primary%20key%20to%20an%20existing%20table%2C%20you,to%20the%20primary%20key%20constraint>.
> 
> 
> 
> Here is some reference info that explains how to add a spatial index
> 
> https://postgis.net/workshops/postgis-intro/indexing.html <https://postgis.net/workshops/postgis-intro/indexing.html>
> 
> 
> Both require the use of a PostgreSQL client for example "psql".
> 
> 
> 
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user