[GRASS-user] "dbmi: Protocol error" with v.out.ogr

[Luí­s Moreira de Sousa]

Hi Markus,

the label field was created by r.to.vect, I am not sure of its purpose. For this particular record it contains an empty string (see below).

Thank you.

s4a=# select * from mal9.mal9_5x5_sec_units where cat = 11133509
AND label IS NULL;
cat | mal | label
-----+-----+-------
(0 rows)

s4a=# select LENGTH(label) from mal9.mal9_5x5_sec_units where cat = 11133509;
length
--------
0
(1 row)

s4a=# \d+ mal9.mal9_5x5_sec_units
Table "mal9.mal9_5x5_sec_units"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------+-----------------------+-----------+----------+---------+----------+--------------+-------------
cat | integer | | | | plain | |
mal | integer | | | | plain | |
label | character varying(10) | | | | extended | |
Indexes:
"mal9_5x5_sec_units_cat" UNIQUE, btree (cat)
Access method: heap

--
Luís

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, January 7, 2021 12:12 PM, Luí­s Moreira de Sousa <luis.de.sousa at protonmail.ch> wrote:

> Dear all,
>
> I have a mapset connected to a Postgres back-end:
>
>> db.connect -p
> driver: pg
> database: s4a
> schema: mal9
> group:
>
> In this mapset there is a large points layer that I need to export. I am trying with v.out.ogr:
>
>> v.out.ogr input=mal9_5x5_sec_units at MAL9 output=/bck/mal9_5x5_sec_units.gpkg format=GPKG
> Exporting 34324866 features...
> dbmi: Protocol error
> ERROR: Cannot select attributes for cat = 11133509
>
> But the attributes for that geometry are accessible in the back-end:
>
>> psql -d s4a
> psql (12.5 (Ubuntu 12.5-0ubuntu0.20.04.1))
> Type "help" for help.
> # select * from mal9.mal9_5x5_sec_units where cat = 11133509;
> cat | mal | label
> ----------+-----+-------
> 11133509 | 0 |
> (1 row)
>
> What could be causing this error? Is there any other way to export this layer?
>
> Thank you.
>
> --
> Luís
>
> Sent with [ProtonMail](https://protonmail.com) Secure Email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20210108/d772e2e5/attachment.html>