Opened 11 years ago

Closed 4 years ago

#1502 closed defect (fixed)

v.select GRASS7 not creating vector table in postgres when schema is different than public

Reported by: pkscwc Owned by: grass-dev@…
Priority: normal Milestone: 7.0.7
Component: Database Version: unspecified
Keywords: v.select, postgres Cc:
CPU: Unspecified Platform: Unspecified

Description

v.select fails to create postgres table when schema is different than public. Perhaps , reason is the name of the table . Which is assigned like schema.map1_schema.map2 . The two dots in the name of the table may be the reason of error. Error says "cross database reference not allowed."

Change History (6)

in reply to:  description comment:1 by mlennert, 11 years ago

Replying to pkscwc:

v.select fails to create postgres table when schema is different than public. Perhaps , reason is the name of the table . Which is assigned like schema.map1_schema.map2 . The two dots in the name of the table may be the reason of error. Error says "cross database reference not allowed."

What does db.connect -p show ? How did you define the schema to use ?

schema.map1_schema.map2 is definitely incorrect.

Moritz

comment:2 by hamish, 10 years ago

Component: DefaultDatabase
Keywords: v.select postgres added
Milestone: 7.0.0

comment:3 by martinl, 7 years ago

Milestone: 7.0.07.0.5

comment:4 by neteler, 6 years ago

Milestone: 7.0.57.0.6

comment:5 by neteler, 5 years ago

Milestone: 7.0.67.0.7

comment:6 by martinl, 4 years ago

Resolution: fixed
Status: newclosed

No activity for a long time. Closing. Feel free to reopen if needed.

Note: See TracTickets for help on using tickets.