Hi Denis,
I use:
uri = QgsDataSourceUri()
uri.setDataSource(schemaName, tableName, geomColumn)
uri.setConnection(thisHostName,
str(thisPort), thisDatabaseName,
"", "", QgsDataSourceUri.SslRequire, thisAuthCfgId)
vLayerUri = uri.uri(False)
vlayer = QgsVectorLayer(vLayerUri, displayName,
s checkbox because QGIS version is
managed by the system administrator.
https://docs.qgis.org/3.4/en/docs/user_manual/introduction/qgis_configuration.html#deploying-qgis-within-an-organization
Le mar. 4 juin 2019 à 06:55, Bernhard Ströbl <mailto:bernhard.stro...@jena.de>> a écrit :
On that occasion:
how can I deactivate the new version information? I get frequent calls
from my users asking if they need to do something. It's kind of annoying
because we use LTS.
Bernhard
Am 03.06.2019 um 18:11 schrieb Tim Sutton:
It takes the version status from QGIS.org
virus
signature database 19173 (20190410) __
The message was checked by ESET Mail Security.
http://www.eset.com
'�z�Zr�r^�)�j[p��Z��'~��zJ&�W����{^��iק
--
Bernhard Ströbl
Anwendungsbetreuer GIS
Kommunale Immobilien Jena
Am Anger 26
07743 Jena
Tel.: 03641 49- 5190
E-Mail: bernhard
Hi Andreas,
I filed a ticket for this very problem a couple of years ago:
https://issues.qgis.org/issues/9160
Bernhard
Am 24.10.2018 um 10:27 schrieb Andreas Neumann:
Hi,
Given a layer with POINT geometries, if only one point is selected, QGIS
doesn't zoom to this point, but only pans to the
Hi Richard,
nocache.qgis.org did the trick for us
thank you for your effort
Bernhard
Am 05.06.2018 um 12:22 schrieb Richard Duivenvoorde:
On 05-06-18 09:54, Richard Duivenvoorde wrote:
On 05-06-18 09:31, Jürgen E. Fischer wrote:
Hi Bernhard,
On Tue, 05. Jun 2018 at 08:29:09 +0200, Bernhard
Hi Richard, hi group,
has anything changed recently? We have -again- since several days
problems mirroring ubuntugis locally:
debmirror --dist=xenial --section=main --arch=i386,amd64 --cleanup
--host=qgis.org --root=ubuntugis-ltr --method=https --rsync-extra=none
/mirrorpath
fails with 403
Hi Antonio,
whilst Nyall is totally right I am still reading here, too. I would
appreciate if you file a ticket so we can shift the discussion there.
The stack trace doesn't tell me anything, I am afraid.
thank you
Bernhard
Am 21.05.2018 um 01:00 schrieb Nyall Dawson:
On 19 May 2018 at
(144.76.174.102).
(note that this one is NOT being cached by cloudflare, so I doubt it is
'the same problem' as earlier)
And I see now:
http://ubuntu.qgis.org/ubuntugis/
which is a repo.
Fixed like this?
Sorry for the inconvenience.
Regards,
Richard Duivenvoorde
On 02-01-18 09:20, Bernhard Ströbl
Hi,
I wish everybody a good start in 2018!
We have -again- a problem mirroring the QGIS repos locally, see [1]. The
ubuntu subdomain is not accessible anymore and going directly to
qgis.org results in the same error as two years ago.
best regards
Bernhard
[1]
reak
document for the `get` removal, see
https://qgis.org/api/api_break.html#qgis_api_break_3_0_QgsAuthManager
<https://qgis.org/api/api_break.html#qgis_api_break_3_0_QgsAuthManager>
On 2017-11-02 14:05, Bernhard Ströbl wrote:
Hi all,
Hi Andreas,
thanks for your feedback.
Ticket filed.
Bernhard
Am 02.11.2017 um 14:19 schrieb Andreas Neumann:
Same for me. Very annoying.
Bernhard please file a ticket and assign it to Alessandro or Luigi.
Thanks,
Andreas
On 2017-11-02 14:05, Bernhard Ströbl wrote:
Hi all,
I cannot
Hi all,
I cannot convince freshly compiled current master 1ffc3fd to save an
authentication database.
Furthermore the Python access to QgsAuthManager via
QgsAuthManager.instance() seems broken, too:
"type object 'QgsAuthManager' has no attribute 'instance'"
Both already worked in a former
Hi Stefan,
although I do not know very much about this topic I wonder how this is
solved with other file-based data sets, e.g. shape. Furthermore I would
not limit csv to Excel. I normally use an editor for csv (and sometimes
LibreOffice). The editor does not lock the file but offers to
Hi,
just my two cents: My users are working in a German administration and
they depend on QGIS having a German UI. They will be puzzled if they are
supposed to use a point instead of the regular komma as decimal
separator. On the other hand they won't expect "5.5" to be a regular
entry into a
Giovanni,
I know you did not target at me :-)
I wanted to express that I would prefer to be able to implement this in
C++ myself but instead of having nothing I tried to make a workaround in
Python.
regards
Bernhard
Am 21.06.2017 um 12:44 schrieb Giovanni Manghi:
Hi Bernhard, thanks for the
Hi Giovanni
Am 20.06.2017 um 14:18 schrieb Giovanni Manghi:
Hi,
Hi,
I would like to raise attention for an issue which was discussed in
length in the qgis-users list [1]
You can ignore the beginning of the discussion where I mixed up "Split
parts" and "Split features".
The split features
methods (you can see how simple the fix i made is). The
advantage of vector.features is that it honors the option setting,
without the developer having to take care of that.
Cheers
2017-01-19 10:43 GMT+01:00 Bernhard Ströbl <bernhard.stro...@jena.de>:
Hi Victor,
what do you think about enh
, regardless of the
config parameter. The change is in 2.18 and master branches
Thanks!
2017-01-18 10:44 GMT+01:00 Bernhard Ströbl <bernhard.stro...@jena.de>:
Hi all,
processing sports the "Save selected features" algorithm. However if in
processing's options you untick "Use o
Hi all,
processing sports the "Save selected features" algorithm. However if in
processing's options you untick "Use only selected features" the
algorithm outputs _all_ features of the input layer. Although I know
that processing works only on selections when the option is ticked IMHO
the
enu.
Bernhard
Am 10.01.2017 um 09:15 schrieb Nathan Woodrow:
File was renamed to Project for a few reasons, mainly for better context
awareness and external non file based projects. No plans to change that
as I think that works well.
On Tue, 10 Jan 2017 6:11 pm Bernhard St
Hi Nathan,
I think the original idea was to have something like a "File" menu, that
many applications have, too. Although it is not named "File". Anyway
IMHO it is a good idea, because many users get general and project's
settings mixed up and I would not favor renaming "Project" to "File"
Hi Tom,
would be great to have your and anybody else's experiences and how tos
available for reference by then. Is there a website where people can
contribute?
Bernhard
Am 06.01.2017 um 00:23 schrieb Tom Chadwin:
Nyall Dawson wrote
I'd say just before/after feature freeze.
Sounds
Hi Nayll and all,
my ideas are more from a user's perspective and from that point of view
I like your first idea most which (hopefully) increases performance and
improves the output.
Moreover I would like to add the following ideas
1) Selection: It would be cool to integrate QGIS' expression
Hi,
just a notice: I experience crashes while zooming if geometries are
invalid. As soon as I fix them the crashes stop.
Setting: Geometries from PostGIS with ST_IsValid(geometry) = false, QGIS
2.* 64bit on Win7
So it could be worth to check your data.
Bernhard
Am 09.11.2016 um 21:37
Rouzaud ha scritto:
Same with Item Browser and qSearch!
On 08/24/2016 07:38 AM, Bernhard Ströbl wrote:
Hi Paolo,
how can I remove the projects I created? I didn't find any button to
do that on hub.
If I cannot do that myself you may remove DataDrivenInputMask and
DigitizingTools now.
I can do
Hi Paolo,
how can I remove the projects I created? I didn't find any button to do
that on hub.
If I cannot do that myself you may remove DataDrivenInputMask and
DigitizingTools now.
best regards
Bernhard
Am 23.08.2016 um 23:06 schrieb Paolo Cavallini:
Hi all,
we are currently busy
changed only for 64bit signed integers in QGIS 2.16.
Details here:
https://github.com/qgis/QGIS/pull/3036
Regards,
Matthias
On 08/08/16 15:47, Bernhard Ströbl wrote:
Hi all,
in former versions QGIS' featureID used to be indentical with the
primary key value of a PostGIS layer (if the field
- why?
3) if yes - since when (version)?
Please enlight me
regards
Bernhard
--
Bernhard Ströbl
Anwendungsbetreuer GIS
Kommunale Immobilien Jena
Am Anger 26
07743 Jena
Tel.: 03641 49- 5190
E-Mail: bernhard.stro...@jena.de
Internet: www.kij.de
Kommunale Immobilien Jena
Eigenbetrieb der Stadt Jena
Hi Patrick,
I did part of what you listed in my Plugin DataDrivenInputMask (Python),
only available for PostGIS, though. Source code and documentation are on
github.
The plugin provides suitable widgets for any supported data type (e.g.
date, boolean, arrays types). You might also want to
As far as I understood the recent plugin licensing discussion on this
list a plugin importing qgis.core or qgis.gui (or OS-pyQt) needs to be
licenced compatible to GPL2, so even in a private repository a plugin
author cannot claim a plugin to be for private use only(?). One could of
course
Hi all,
I experience singular bug reports [1], [2] about icons for my plugin
DigitizingTools not showing. Is anybody aware of some misconfiguration
in the plugin or at the user's that may cause these problems?
regards
Bernhard
[1] http://hub.qgis.org/issues/14503
[2]
Hi Manuel,
instead of developping a new plugin my plugin DataDrivenInputMask [1]
might suit your needs. It handles all kinds of relations and referential
integrity out of the box (if thoroughly defined in the DB). Tickets,
feedback, feature requests welcome.
Bernhard
[1]
w :)
Regards Casper
-Original Message-
From: Bernhard Ströbl [mailto:bernhard.stro...@jena.de]
Sent: 8. april 2016 12:55
To: Casper Børgesen (CABO); qgis-developer@lists.osgeo.org
Subject: Re: [Qgis-developer] Warning from DigitizingTools about CRS
mismatch
Hi Casper,
I meant the CRS set
in whether the warning should be
shown or not?
We are running QGIS 2.14.0 64 bit on Windows 7.
Regards Casper
-Original Message-
From: Qgis-developer [mailto:qgis-developer-boun...@lists.osgeo.org] On Behalf
Of Bernhard Ströbl
Sent: 8. april 2016 10:38
To: qgis-developer@lists.osgeo.org
Hi Casper,
DigitizingTools compares _only_ the SRS-id (SRS =
SpatialReferenceSystem) of the project and the layer. If they missmatch
the warning is thrown so the user gets a hint why certain functions are
greyed out.
Thus relevant is not the prj file but the SRS assigned to the layer and
the
Hi,
just to add another thought: In the past I bypassed disable print
settings in pdf documents by using a pdf viewer other than AdobeAcrobat
Reader (gsView in that case) and thus was able to print. So setting
flags does not necessarily mean that all pdf readers out there honor them.
I opened a ticket: http://hub.qgis.org/issues/14506
Bernhard
Am 14.03.2016 um 10:33 schrieb Bernhard Ströbl:
Hi,
I decided to post this on the dev list and not on the user's list.
Problem description: task is to export a single layer to dxf, CRS of
both, the project and the layer is EPSG
Hi,
just my 2 ct:
I agree with Paolo that normal users do not know SQL, on the other hand
there might be users that do not know spreadsheet syntax either (e.g. me
:) which spreadsheet BTW: Excel? LO? or do they use the same syntax? SQL
would be a standardized approach (and is the syntax
Hi,
I am currently rewriting a processing alg. What I need is
- either a temporary layer (I could do that with QGIS Python api but
wondered if there is a helper function for that)
- or (prefered) get the layer created by output (and modify it further)
I cannot access it, this is my code:
Hi,
I decided to post this on the dev list and not on the user's list.
Problem description: task is to export a single layer to dxf, CRS of
both, the project and the layer is EPSG:25832 (units = metres). Using
layer - save as with dxf results in a dxf file with units = inches
(although
Hi Paolo,
some comments below
Am 09.03.2016 um 11:11 schrieb Paolo Cavallini:
Hi all,
perhaps I'm missing something, but I find usability of current search
mechanism a bit cumbersome. AFAICT, to search a set of features, the
user should:
* select on the legend the layer to be searched
* open
)
I'll try to look at the documentation and small usability issues listed
in this thread soon.
thanks
Bernhard
On 03/03/2016 12:16, Bernhard Ströbl wrote:
Hi Andreas and all,
sorry to hijack your thread but my question is related as I am also
trying to evaluate the new feature virtual layer
Hi Andreas and all,
sorry to hijack your thread but my question is related as I am also
trying to evaluate the new feature virtual layer.
My first tests resulted in QGIS freezing upon clicking "Test" or "OK"
(2.14.0 on Ubuntu 14.04 64 bit). It finally turned up it was the layer's
names
Hi Richard,
thank you for your effort. ubuntu.qgis.org is working now
regards
Bernhard
Am 22.01.2016 um 18:58 schrieb Richard Duivenvoorde:
On 22-01-16 11:09, Bernhard Ströbl wrote:
Hi,
we are trying to mirror the ubuntugis repository so users can install
and update from this (inhouse
Hi,
we are trying to mirror the ubuntugis repository so users can install
and update from this (inhouse) mirror.
However trying to mirror with "debmirror" a 403 error is returned.
Further analysis revealed that "CloudFlare" at qgis.org refuses
debmirror's user agent.
Question 1: bug or
Dakota
QGIS Support/Development | Boundless
lshaf...@boundlessgeo.com <mailto:lshaf...@boundlessgeo.com>
On Tue, Jan 12, 2016 at 8:14 AM, Bernhard Ströbl
<bernhard.stro...@jena.de <mailto:bernhard.stro...@jena.de>> wrote:
Hi Luigi,
many thanks! That was the key.
I no
Hi all,
my goal is that my users do not save their PostgreSQL passwords in clear
text but that they use the new Authentification system to do so. For my
plugins I would need access to the PostgreSQL username and password,
though. Is this generally possible in spite of security considerations
/mastering-qgis
**
On 12 January 2016 at 12:47, Bernhard Ströbl <bernhard.stro...@jena.de> wrote:
Hi all,
my goal is that my users do not save their PostgreSQL passwords in clear
text but that th
Hi,
workaround: use dblink to mirror the relations from the other dbs into
the "main" db
Bernhard
Am 25.11.2015 um 22:03 schrieb Tony Pham:
Hi all,
For the WSGI Search capabilities on QGIS Web Client, is it possible to
establish search capabilities using multiple databases (i.e., tables
Am 24.11.2015 um 10:47 schrieb Alessandro Pasotti:
2015-11-24 10:42 GMT+01:00 Matthias Kuhn >:
Hi Marco
Good to have your feedback, you probably know the problem best.
On 11/24/2015 09:28 AM, Marco Hugentobler wrote:
Hi
Hi all,
Am 24.11.2015 um 11:01 schrieb Marco Hugentobler:
Hi Alessandro, Matthias
>Is there no requirement for multi types?
Afaik, the problem for f-tools are not the multi types, but only the
geometry collections (containing geometries with different shape type).
In my experience, if geos
be any chosen vector format, or at least
supports geopackage/spatialite/postgres as output.
Andreas
On 22.10.2015 15:26, Bernhard Ströbl wrote:
IMHO all ftools should be replaced by native QGIS processing
algorithms. For "simple" users it may be not feasible (or not allowed)
to install
:
shp is the default format for temp files, and as such it is used in
the modeler for intermediate results. That is, however, very easy to
change, so if we agree on any other format, it can be changed and set
as the default for Processing
2015-10-22 16:08 GMT+02:00 Bernhard Ströbl <bernhard.s
IMHO all ftools should be replaced by native QGIS processing algorithms.
For "simple" users it may be not feasible (or not allowed) to install
additional software. Therefore native QGIS algorithms should be improved
to be fast, robust and offering choices the users need (see recent
discussion
eveloper@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
--
Bernhard Ströbl
Anwendungsbetreuer GIS
Kommunale Immobilien Jena
Am Anger 26
07743 Jena
Tel.: 03641 49- 5190
E-Mail: bernhard.stro...@jena.de
Internet: www.kij.de
Kommunale Immobilien Jena
Eige
:Qgis-developer@lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/qgis-developer
___
Qgis-developer mailing list
Qgis-developer@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-developer
--
Bernhard Ströbl
Anwendungsbetreuer GIS
Kommunale Immobilien Jena
Am A
Hi Martin,
Am 24.09.2015 um 10:56 schrieb Martin Dobias:
Hi Tim
On Thu, Sep 24, 2015 at 4:20 PM, Tim Sutton > wrote:
Hi
Labelling raster cells would be awesome!
Indeed - identify tool or value tool are often not good enough when one
wants
Hallo Andreas,
do you mean the splash screen at startup? It shows ok for current master
on Ubuntu behind a proxy.
Bernhard
Am 18.09.2015 um 15:02 schrieb Andreas Neumann:
Hi,
I noticed that the new QGIS startscreen from QGIS master works without a
proxy, but not with a proxy. Is this new
de to work on
this.
And another +1 if we get some unittests for the algorithms. They are
actually perfect candidates for unittests.
Kind regards
Matthias
On 09/14/2015 09:05 AM, Bernhard Ströbl wrote:
Hi Paolo,
just a thought: AFAIK fTools does not use 3rd party backends, so the
question of bulle
14.09.2015 um 09:48 schrieb Matthias Kuhn:
Hi Bernhard
On 09/14/2015 09:39 AM, Bernhard Ströbl wrote:
Hi Matthias,
Am 14.09.2015 um 09:31 schrieb Matthias Kuhn:
Hi Bernhard,
The current code redundancy does have some severe issues like:
* Algorithms may give different results from the vector
Hi Paolo,
just a thought: AFAIK fTools does not use 3rd party backends, so the
question of bulletproofness in conjunction with fTools IMHO should only
be raised for those algorithms that are currently in "QGIS
geoalgorithms". (Otherwise I fully agree: the rest should work flawlessly)
As I
Hi Arnaud,
I would like add two things to (the end of) your list:
* Have a way to add icons to the algorithms
* Improve (and translate) algorithms' documentation
Bernhard
Am 14.09.2015 um 10:30 schrieb Arnaud Morvan:
Normally, I would be present at next hackfest and interested in working
on
Hi all,
I recently recoded Processing's Dissolve. The changes fundamentally
reduced the runtime of the algorithm. In the pull request discussion [1]
Matthias and I came to a point where we were wondering about the future
of fTools and Processing. I found this discussion from May [2]. What is
Hi Yves,
Am 10.09.2015 um 09:27 schrieb Yves Jacolin:
Hello,
On Thursday, September 10, 2015 8:50:24 Bernhard Ströbl wrote:
Hi Yves,
I have only experience with PostgreSQL but I assume that sqlite behaves
similar. If you edit a feature in QGIS your layer is in edit mode
(allowing for undo
Hi Yves,
I have only experience with PostgreSQL but I assume that sqlite behaves
similar. If you edit a feature in QGIS your layer is in edit mode
(allowing for undo/redo). Changes are committed only when you click on
the respective button. This results in an update statement sent to your
db
Hi Christian,
what type of layer are you writing in? Is the layer's source utf-8
encoded and is its coding set to utf-8?
When I encountered encoding problems I found this [1] site very
informative and also fun to read.
Bernhard
[1] http://www.joelonsoftware.com/articles/Unicode.html
Am
Hi everybody,
I try to do the following from the Python console:
g=iface.activeLayer().selectedFeatures()[0].geometry()
returns a QgsGeometry objekt but as soon as I want to do anything with
it QGIS crashes (layer is a memory line layer but a PostGIS linestring
layer behaves the same). Any
Hm,
the following code returns the geometry ok:
for feat in iface.activeLayer().selectedFeatures():
g=feat.geometry()
break
Bernhard
Am 25.06.2015 um 08:43 schrieb Bernhard Ströbl:
Hi everybody,
I try to do the following from the Python console:
g=iface.activeLayer().selectedFeatures()[0
been finished?
thank you for your help
Bernhard
Am 25.06.2015 um 09:00 schrieb Martin Dobias:
Hi Bernhard
that's a long standing unresolved issue with python bindings:
http://hub.qgis.org/issues/777
Regards
Martin
On Thu, Jun 25, 2015 at 2:43 PM, Bernhard Ströbl
bernhard.stro...@jena.de
in the future once
issue #777 is resolved,
Cheers,
Matthias
On 06/25/2015 09:10 AM, Bernhard Ströbl wrote:
Hi Martin,
I was not aware of this bug, thanks for pointing me towards it. As
posted previously I found a workaround but if I use
geometryAndOwnership() as proposed in #777 do I have to do
database 11790 (20150615) __
The message was checked by ESET Mail Security.
http://www.eset.com
--
Bernhard Ströbl
Anwendungsbetreuer GIS
Kommunale Immobilien Jena
Am Anger 26
07743 Jena
Tel.: 03641 49- 5190
E-Mail: bernhard.stro...@jena.de
Internet: www.kij.de
Kommunale Immobilien Jena
processes=5 threads=15 display-name=%{GROUP}
WSGIScriptAlias /wsgi/ /usr/lib/cgi-bin/wsgi/
WSGIScriptAliasMatch ^/wsgi/([^/]+) /usr/lib/cgi-bin/wsgi/$1.wsgi
I have internal error 500. You I'm not understand again
sorry
E
2015-04-23 9:42 GMT+04:00 Bernhard Ströbl bernhard.stro...@jena.de
Hi Enzo,
I did not realize you solved it in the meantime :-)
regards
Bernhard
Am 24.04.2015 07:42, schrieb Bernhard Ströbl:
Hi Enzo,
check Apache's error log (located e.g. in /var/log/apache2) and see if
there is some more information.
Bernhard
Am 23.04.2015 19:33, schrieb Enzo Cocca:
Hi
Hi Enzo,
as I wrote in a previous post: Make sure the user running the apache
process has access to the wsgi directory. Try putting the wsgi in
/home/somthing e.g. in /var/www/wsgi
Bernhard
Am 22.04.2015 14:07, schrieb Enzo Cocca:
Hi all,
I looked for a solution but without results.
After
bernhard and
I have put my wsgi folder in /var/www/html but I continue to have the error:
illegal charcther #! /usr/bin/python
I have reinstalled libapache2-mod-wsgi, but nothing
I use ubuntu server 14.04 apache 2.4 python 2.7
Thanks at all for help
E
2015-04-22 16:32 GMT+04:00 Bernhard Ströbl
/python
So I not understand the problem
Thanks!!
2015-04-22 10:51 GMT+04:00 Bernhard Ströbl bernhard.stro...@jena.de
mailto:bernhard.stro...@jena.de:
Hi,
the wsgi-Script is a script to be run _on the server_, not in the
client.
Bernhard
Am 22.04.2015 08:47, schrieb
Hi all,
I wanted to start working on #12446 [1] however I did not find any
documentation on how to use the new AdvancedDigitizing (CAD input queue)
in Python.
Any help appreciated.
Bernhard
[1] http://hub.qgis.org/issues/12446
__ Information from ESET Mail Security, version of
/wsgi/ /home/www/wsgi/
WSGIScriptAliasMatch ^/wsgi/([^/]+) /home/www/wsgi/$1.wsgi
and than I restarted apache
Where I wrong?
2015-04-22 11:26 GMT+04:00 Bernhard Ströbl bernhard.stro...@jena.de
mailto:bernhard.stro...@jena.de:
Hi Enzo,
your error indicates that the script
Hi,
the wsgi-Script is a script to be run _on the server_, not in the client.
Bernhard
Am 22.04.2015 08:47, schrieb Enzo Cocca:
Hi,
I have one questionç
I try to write a searchtext in the client, Firebug gives the error
message:
illegal character
#!/usr/bin/python
Someone have a idea??
key field when
loading it.
(And maybe QGIS could be slightly smarter by not suggesting a boolean
field by default?)
On 26-03-15 11:07, Bernhard Ströbl wrote:
Hi Raymond,
Am 26.03.2015 10:57, schrieb Raymond Nijssen:
Thanks Regis, that was exactly the issue. The (boolean!) field
'inonderzoek
Hi Raymond,
Am 26.03.2015 10:57, schrieb Raymond Nijssen:
Thanks Regis, that was exactly the issue. The (boolean!) field
'inonderzoek' was used as a key. When I change that to 'gid' in the Add
PostGIS Table dialog, everything works correctly.
Can anyone tell me why QGIS picks that boolean
the foreign key to ON DELETE CASCADE or ON DELETE SET NULL
is unfortunately not possible.
Best regards,
Thibaut.
2015-03-03 12:10 GMT+01:00 Bernhard Ströbl bernhard.stro...@jena.de
mailto:bernhard.stro...@jena.de:
Hi,
the question is how you define your foreign key [1], namely what you
Hi,
the question is how you define your foreign key [1], namely what you put
for ON DELETE (you have either NO ACTION or RESTRICT, which throw the
error you receive) If you set ON DELETE CASCADE the operation would be
deleted, too, probably not what you want. Maybe you should set ON DELETE
try:
uri.setDataSource('public', 'persones', None, '', 'id')
Bernhard
Am 23.02.2015 16:18, schrieb Alexandre Busquets:
Hi,
I can't add non geometry tables from postgres with pyqgis, this is my code
uri = QgsDataSourceURI()
uri.setConnection(bd_host, bd_port, bd_db, bd_user,
Hi Andreas,
I do not think that multi-core rendering is the issue here as Remi
mentions to have experienced crashes since QGIS 1.8.
Remi,
I am using QGIS with Postgres/PostGIS with some dozens of users on a
central database _without_ any issues in QGIS (except the multi-core
issue Andreas
Hi Luca,
this is a bit off topic but when you store your data in PostgreSQL you
might want to try out the DataDrivenInputMask plugin [1] which has a lot
of (database) intelligence in the form and can be customized to hold
even more. Maybe you do not need to customize QGIS' forms any more.
Hi,
no solution but some thoughts. You could store all changes of each user
into a separate table and create a dedicated view for each user
combining the changed datasets in his/her user table and those unchanged
by this user from the original table.
The user table would have a field
Hi,
I wasn't aware of this. Although I do not understand why one should put
points and lines in the _same_ table, geometries are allowed to be NULL
if the field does not have a NOT NULL constraint. I see two possible
solutions
1) mark the dataset as having no geometry
2) (preferred) do only
Hi Nathan,
which ticket are you refering to?
I was about to roll out QGIS 2.6 for Windows (both 32 and 64 bit).
thanks
Bernhard
Am 12.11.2014 12:00, schrieb Nathan Woodrow:
Hey,
Mainly for Jurgen. Is there any possibility of getting a patched 2.6.1
into the Windows installers and binaries.
Hi,
just a question: are you trying to superimpose this on top of the
out-of-the-box node tool or are you planning on creating a new tool that
copies the node tool?
The first is not so simple I assume, the second either (plus it does not
make too much sense to rewrite core functionality in
Hi Matthias,
Am 14.10.2014 09:56, schrieb Matthias Kuhn:
Hi Bernhard
- shouldn't create virtual field be the default when layer is not in
edit mode?
I think it's more predictable (and therefore increases usability) for
users if it's either always on or always off by default. Don't you
Hi Matthias,
thank you for your work!
However I have some small issues and a bug [1]
- I do not see any notification when not in edit mode but my action
requires edit mode (edit mode is turned on, though, when clicking OK)
- shouldn't create virtual field be the default when layer is not in
Hi Matthias,
there seems to be a small bug in the add field stuff: scenario
1) add a virtual field
2) add a permanent field = field is added but marked as virtual
(symbol) and name is that of the virtual field added in step 1) BUG!
3) close and reopen layer properties = field from step 2) is
Hi Matthias
Am 07.10.2014 14:06, schrieb Matthias Kuhn:
Thank you for testing Bernhard,
On 07.10.2014 10:06, Bernhard Ströbl wrote:
Hi Matthias,
there seems to be a small bug in the add field stuff: scenario
1) add a virtual field
2) add a permanent field = field is added but marked
Hi,
IMHO the current behaviour is not optimal. I often see my users having
the same table opened several times because the expected behaviour is
that if it is already open it comes to focus (similar as with opening
files). If the layer has many features opening the same table a second
(or
Hi Matthias,
Am 07.10.2014 14:40, schrieb Matthias Kuhn:
Hi Bernhard,
On 07.10.2014 14:28, Bernhard Ströbl wrote:
tested with e5850f3
to your question: I think the current editing-mode behavior is
intuitive. What is not intuitive is that the expression editor can
only be launched when
Am 07.10.2014 15:07, schrieb Matthias Kuhn:
Hi
On 07.10.2014 14:56, Bernhard Ströbl wrote:
I think if the user wants to add a permanent field with the help of an
expression the current solution with the field calculator is fine. I
don't see any benefit that the add field dialog would have
This works for me:
writer = QgsVectorFileWriter(my_shapes.shp, CP1250,
QgsFields(),QGis.WKBLineString, None, ESRI Shapefile)
QGIS 2.4 64 bit on Win7
Which QGIS version do you use?
Bernhard
Am 07.10.2014 16:21, schrieb Luca Manganelli:
Hi, in Python, if I do:
writer =
+1
Bernhard
Am 25.09.2014 08:56, schrieb Arnaud Morvan:
What about to translate the processing plugin ?
There is no doubt that processing is more powerfull/modular than the old
ftools, but users who don't speek english find that the processing
module and its toolbox is less accessible than
1 - 100 of 246 matches
Mail list logo