[Qgis-user] QGIS Input Form for PostGIS

[Bernhard Ströbl]

Hi Jakob,

although a bit late: Have you tried the plugin DataDrivenInputMask [1]?
By using it there is no need to fiddle with QGIS relations, the drawback 
is that there is no undo.
You have to properly define foreign keys and not null columns for the 
plugin to work. And, as Andreas already pointed out, indices on foreign 
key columns are normally advisable.

Bernhard

[1] http://plugins.qgis.org/plugins/DataDrivenInputMask/

Am 04.08.2017 um 09:39 schrieb 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
>>
>>
>>


__________ Information from ESET Mail Security, version of virus signature database 15884 (20170809) __________

The message was checked by ESET Mail Security.
http://www.eset.com