[GRASS-dev] [GRASS GIS] #1081: "Attribute Table Manager" not show data and v.extract doesn't work

#1081: "Attribute Table Manager" not show data and v.extract doesn't work
--------------------+-------------------------------------------------------
Reporter: zarch | Owner: grass-dev@lists.osgeo.org
     Type: defect | Status: new
Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-trunk
Keywords: | Platform: Linux
      Cpu: x86-64 |
--------------------+-------------------------------------------------------
Hello,

I have a big vector table (with areas) with 22604 rows and more than 100
columns. I'm using grass-trunk 42416 on 64bit Linux system.

If I try to visualise the attributes with "Attribute Table Manager"
grass70 doesn't
work with both case using 'dbf' and 'pg' driver.
Instead if I try to make a query from "Map Display" or if I try to use
v.db.select they
work properly.
The "Attribute Table Manager" works fine with other small vector map (with
Line
and Polyline).

Moreover I get this error:
{{{
> v.extract --overwrite input=fustaia output=try01 \
  where='accifus=1 AND ripresa>0'
ERROR: Database connection not defined for layer <-1>
}}}

This is my actually db connection:
{{{
> v.db.connect -g map=fustaia
1/public.fustaia|public.fustaia|cat|grassdb|pg
}}}

With grass64r5 the command v.extract and the window "Attribute Table
Manager"
work fine.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1081&gt;
GRASS GIS <http://grass.osgeo.org>

#1081: "Attribute Table Manager" not show data and v.extract doesn't work
---------------------+------------------------------------------------------
  Reporter: zarch | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-trunk
Resolution: | Keywords:
  Platform: Linux | Cpu: x86-64
---------------------+------------------------------------------------------
Comment (by martinl):

Replying to [ticket:1081 zarch]:
> I have a big vector table (with areas) with 22604 rows and more than 100
> columns. I'm using grass-trunk 42416 on 64bit Linux system.
>
> If I try to visualise the attributes with "Attribute Table Manager"
grass70 doesn't
> work with both case using 'dbf' and 'pg' driver.

What do you mean by "doesn't work"? Any error message, or so? BTW ATM
needs some optimalization for larger tables, it can be very slow.

> Moreover I get this error:
{{{
> > v.extract --overwrite input=fustaia output=try01 \
> where='accifus=1 AND ripresa>0'
> ERROR: Database connection not defined for layer <-1>
}}}

Should be fixed in r42420.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1081#comment:1&gt;
GRASS GIS <http://grass.osgeo.org>

#1081: "Attribute Table Manager" not show data and v.extract doesn't work
---------------------+------------------------------------------------------
  Reporter: zarch | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.extract
  Platform: Linux | Cpu: x86-64
---------------------+------------------------------------------------------
Changes (by martinl):

* cc: martinl (added)
  * keywords: => v.extract

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1081#comment:2&gt;
GRASS GIS <http://grass.osgeo.org>

#1081: "Attribute Table Manager" not show data and v.extract doesn't work
---------------------+------------------------------------------------------
  Reporter: zarch | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.extract
  Platform: Linux | Cpu: x86-64
---------------------+------------------------------------------------------
Comment (by zarch):

Replying to [comment:1 martinl]:
> Replying to [ticket:1081 zarch]:
> > I have a big vector table (with areas) with 22604 rows and more than
100
> > columns. I'm using grass-trunk 42416 on 64bit Linux system.
> >
> > If I try to visualise the attributes with "Attribute Table Manager"
grass70 doesn't
> > work with both case using 'dbf' and 'pg' driver.
>
> What do you mean by "doesn't work"? Any error message, or so? BTW ATM
needs some optimalization for larger tables, it can be very slow.

I mean that no any attributes it's shown (I wait for 10 minuts) with
grass64 to see the same table, I need more or less about 1 minut.

> > Moreover I get this error:
> {{{
> > > v.extract --overwrite input=fustaia output=try01 \
> > where='accifus=1 AND ripresa>0'
> > ERROR: Database connection not defined for layer <-1>
> }}}
>
> Should be fixed in r42420.
yes, now it's working! thank's

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1081#comment:3&gt;
GRASS GIS <http://grass.osgeo.org>

#1081: "Attribute Table Manager" not show data and v.extract doesn't work
---------------------+------------------------------------------------------
  Reporter: zarch | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: normal | Milestone: 7.0.0
Component: Vector | Version: svn-trunk
Resolution: fixed | Keywords: v.extract
  Platform: Linux | Cpu: x86-64
---------------------+------------------------------------------------------
Changes (by neteler):

  * status: new => closed
  * resolution: => fixed

Comment:

Replying to [comment:3 zarch]:
> Replying to [comment:1 martinl]:
> > Replying to [ticket:1081 zarch]:
> > > I have a big vector table (with areas) with 22604 rows and more than
100
> > > columns. I'm using grass-trunk 42416 on 64bit Linux system.
> > >
> > > If I try to visualise the attributes with "Attribute Table Manager"
grass70 doesn't
> > > work with both case using 'dbf' and 'pg' driver.
> >
> > What do you mean by "doesn't work"? Any error message, or so? BTW ATM
needs some optimalization for larger tables, it can be very slow.
>
> I mean that no any attributes it's shown (I wait for 10 minuts) with
grass64 to see the same table, I need more or less about 1 minut.

Continued in #2124, closing here.

--
Ticket URL: <http://trac.osgeo.org/grass/ticket/1081#comment:4&gt;
GRASS GIS <http://grass.osgeo.org>