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

[Luí­s Moreira de Sousa via grass-user]

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 <nete...@osgeo.org> wrote:

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

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