Opened 14 years ago

Closed 10 years ago

#1081 closed defect (fixed)

"Attribute Table Manager" not show data and v.extract doesn't work

Reported by: zarch Owned by: grass-dev@…
Priority: normal Milestone: 7.0.0
Component: Vector Version: svn-trunk
Keywords: v.extract Cc: martinl
CPU: x86-64 Platform: Linux

Description

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.

Change History (4)

in reply to:  description ; comment:1 by martinl, 14 years ago

Replying to 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.

comment:2 by martinl, 14 years ago

Cc: martinl added
Keywords: v.extract added

in reply to:  1 ; comment:3 by zarch, 14 years ago

Replying to martinl:

Replying to 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

in reply to:  3 comment:4 by neteler, 10 years ago

Resolution: fixed
Status: newclosed

Replying to zarch:

Replying to martinl:

Replying to 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.

Note: See TracTickets for help on using tickets.