Opened 9 years ago

Last modified 7 years ago

#2005 new defect

v.db.addtable and postgres schema problem

Reported by: davidinosauro Owned by: grass-dev@…
Priority: normal Milestone: 6.4.6
Component: Shell Scripts Version: 6.4.2
Keywords: v.db.addtable Cc:
CPU: Unspecified Platform: Unspecified

Description

Hi all! I'm using GRASS GIS 6.4 with a postgres database connection to a non-default schema. Most of tools are fine with it, but v.db.connect has a wired behavior:

When I run v.db.addtable on a map obtained with v.dissolve (thus without attribute tables set), it gives a big output (attached) among wich some "no such table" message from postgres.

After the call, the database table is created in the right schema (the one defined with db.connect), but the database connection is NOT schema-qualified:

# v.db.connect -p map=path_30_2__999_poly
Vector map <path_30_2__999_poly@pinzolo> is connected by:
layer <1> table <path_30_2__999_poly> in database <host=localhost,port=5432,dbname=thesis> through driver <pg> with key <cat>

In fact, at subsequent usage of that table, postgres complains that the requested table (searched in public schema) does not exist.

As a workaround, I used v.db.addtable with table=<schema_name><map_name>

Cheers Davide

Attachments (1)

v.db.addtable.error (11.1 KB ) - added by davidinosauro 9 years ago.
v.db.addtable full error

Download all attachments as: .zip

Change History (4)

by davidinosauro, 9 years ago

Attachment: v.db.addtable.error added

v.db.addtable full error

in reply to:  description comment:1 by mmetz, 9 years ago

Replying to davidinosauro:

Hi all! I'm using GRASS GIS 6.4 with a postgres database connection to a non-default schema. Most of tools are fine with it, but v.db.connect has a wired behavior:

When I run v.db.addtable on a map obtained with v.dissolve (thus without attribute tables set), it gives a big output (attached) among wich some "no such table" message from postgres.

Please try trunk r56701.

comment:2 by hamish, 9 years ago

Component: DatabaseShell Scripts
Keywords: v.db.addtable added
Milestone: 6.4.4
Version: unspecified6.4.2

comment:3 by neteler, 7 years ago

Milestone: 6.4.46.4.6
Note: See TracTickets for help on using tickets.