[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. In the case of this particular record it is just 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 9:46 PM, Markus Neteler <neteler at osgeo.org> wrote:

> Hi Luí­s,
>
> On Thu, Jan 7, 2021 at 12:13 PM Luí­s Moreira de Sousa via grass-user
> grass-user at lists.osgeo.org wrote:
>
> > Dear all,
> > I have a mapset connected to a Postgres back-end:
>
> ...
>
> > select * from mal9.mal9_5x5_sec_units where cat = 11133509;
> >
> > ============================================================
> >
> > cat | mal | label
> > ----------+-----+-------
> > 11133509 | 0 |
> > (1 row)
>
> Just to be sure: "label" is ready empty here and does not contain a
> spurious character with "funny" encoding not liked by DBMI?
>
> Best
> Markus

</neteler at osgeo.org>