[GRASS-user] v.to.db in GRASS 7.8 requires 'overwrite' if column exists but flag is invalid

GRASS GRASS user
1

Dear list,

in GRASS 7.8 v.to.db creates a new column in contrast to previous versions where it column had to exist before.

According to the manual “If the column exists, the –overwrite flag is required to overwrite it”. However, this flag does not exist. Hence, if the column is present, it is not upated, giving:

ERROR: Column <length_new> exists. To overwrite, use the --overwrite flag

When useing “overwrite”, it gives:

Invalid flag value: overwrite

Another issue is that even if the flag would work, it would no longer be compatible with previous versions that also do not know the flag but need the column to exist.

Can anybody please advice me what to do?

Thanks,

Mira

··· 
-- 
Dr. Mira Kattwinkel
Quantitative Landscape Ecology
iES Landau, Institute for Environmental Sciences
University of Koblenz-Landau
Fortstraße 7
76829 Landau
Germany
Phone: + 49 6341 280-31553
Office: Building I, Room 2.02
2

Mira Kattwinkel wrote

Dear list,

in GRASS 7.8 v.to.db creates a new column in contrast to previous
versions where it column had to exist before.

According to the manual "If the /column/ exists, the *--overwrite* flag
is required to overwrite it". However, this flag does not exist. Hence,
if the column is present, it is not upated, giving:

ERROR: Column
<length_new>
exists. To overwrite, use the --overwrite flag

When useing "overwrite", it gives:

Invalid flag value: overwrite

Another issue is that even if the flag would work, it would no longer be
compatible with previous versions that also do not know the flag but
need the column to exist.

Can anybody please advice me what to do?

yes there was a change in the module behaviour, see

https://github.com/OSGeo/grass/issues/770

I had the same issue.

regarding using this new behaviour in scripts, see e.g.

https://github.com/OSGeo/grass-addons/commit/943d9c72a51716608f6a358a40dd114e38eaa9cf

on the command line, just add --overwrite,

e.g. v.to.db --overwrite map=soils type=centroid option=area
columns=area_size unit=h

but in the v.to.db GUI, there is no overwrite available.

please open an issue about that.

-----
best regards
Helmut
--
Sent from: http://osgeo-org.1560.x6.nabble.com/Grass-Users-f3884509.html

3

On Thu, Jul 16, 2020 at 12:34 PM Helmut Kudrnovsky <hellik@web.de> wrote:

Mira Kattwinkel wrote
> Dear list,
>
> in GRASS 7.8 v.to.db creates a new column in contrast to previous
> versions where it column had to exist before.

...

yes there was a change in the module behaviour, see

https://github.com/OSGeo/grass/issues/770

I had the same issue.

...

please open an issue about that.

For the list record: reported issue has been fixed by Huidae and backported.

Markus

4

Sorry to open this again:

Was the change really backported to GRASS 7.8? I still cannot set an overwrite flag in the gui.

I use 7.8.3-1~bionic1

on linux mint 19

from http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu bionic/main amd64

Is that the wrong source?

Thanks,

Mira

On 20/07/2020 22.35, Markus Neteler wrote:

On Thu, Jul 16, 2020 at 12:34 PM Helmut Kudrnovsky <hellik@web.de> wrote:

Mira Kattwinkel wrote

Dear list,

in GRASS 7.8 v.to.db creates a new column in contrast to previous
versions where it column had to exist before.

...

yes there was a change in the module behaviour, see

https://github.com/OSGeo/grass/issues/770

I had the same issue.

...

please open an issue about that.

For the list record: reported issue has been fixed by Huidae and backported.

Markus
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user

--
Dr. Mira Kattwinkel
Quantitative Landscape Ecology
iES Landau, Institute for Environmental Sciences
University of Koblenz-Landau
Fortstraße 7
76829 Landau
Germany
Phone: + 49 6341 280-31553
Office: Building I, Room 2.02

5

Hi Mira,

AFAICT, yes. See here: https://github.com/OSGeo/grass/commit/1be7bfe59f1c71b12fe60a26a3aa313b9a599e31

However, the fix will only come with the new release, 7.8.4. In the meantime, you can download the source code and compile release branch to get this bugfix. See here: https://grasswiki.osgeo.org/wiki/Compile_and_Install_Ubuntu#Quick_instructions. After installing dependencies, go to section b)

Others using Ubuntu or Mint will know better if the instructions are up to date

best,
Vero

El lun., 27 jul. 2020 a las 14:18, Mira Kattwinkel (<kattwinkel-mira@uni-landau.de>) escribió:

Sorry to open this again:

Was the change really backported to GRASS 7.8? I still cannot set an
overwrite flag in the gui.

I use 7.8.3-1~bionic1

on linux mint 19

from http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu
bionic/main amd64

Is that the wrong source?

Thanks,

Mira

On 20/07/2020 22.35, Markus Neteler wrote:

On Thu, Jul 16, 2020 at 12:34 PM Helmut Kudrnovsky <hellik@web.de> wrote:

Mira Kattwinkel wrote

Dear list,

in GRASS 7.8 v.to.db creates a new column in contrast to previous
versions where it column had to exist before.
…

yes there was a change in the module behaviour, see

https://github.com/OSGeo/grass/issues/770

I had the same issue.
…
please open an issue about that.
For the list record: reported issue has been fixed by Huidae and backported.

Markus

grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user

–
Dr. Mira Kattwinkel
Quantitative Landscape Ecology
iES Landau, Institute for Environmental Sciences
University of Koblenz-Landau
Fortstraße 7
76829 Landau
Germany
Phone: + 49 6341 280-31553
Office: Building I, Room 2.02

grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user