[Qgis-user] QGIS Input Form for PostGIS

[Andreas Neumann]

Hi Jakob,

I don't think there is much background information or documentation 
available on relations.

The obvious questions to you are:

- What means "big" (how many records are you dealing with)?

- I know this sounds silly - but are your tables properly indexed (you 
don't have to index primary keys, but other columns that are used in 
relations need an index)

- What exact QGIS version are you using? 2.18.x - in the about dialogue 
you can find this, including the exact github version string

- if we can't help you further, it may help to see your create table 
statements (including all indexes)

Andreas


On 03.08.2017 11:47, Jakob Miksch wrote:
>
> Hello,
>
> I have a (rather big) Postgres/PostGIS database that basically looks 
> like this: https://ibb.co/bK7PKv
>
> I want to use QGIS for editing and inserting data.
>
> I already found these ressources:
>
> https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/vector_properties.html#fields-properties
>
> https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/attribute_table.html#creating-one-or-many-to-many-relations
>
> https://docs.qgis.org/2.18/en/docs/training_manual/create_vector_data/forms.html
>
> I tried it: I created the relations and built custom forms.
>
> However, when I want to insert or edit something. QGIS becomes really 
> slow and crashes finally. But before I describe the problems in more 
> detail I want to read more about it. I find the documentation (linked 
> above) a bit too little.
>
> So, my question:
>
> Is there any documentation I have missed?
>
> Is there any book (chapter) you can recommend?
>
> Do you know of any example where QGIS is used for entering data into 
> many related tables in Postgres/PostGIS at once?
>
> I am thankful for any hint or resource.
>
> Jakob
>
>
>
> _______________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170804/f784ed77/attachment.html>