[GRASS-user] v.patch ERROR: Column names differ

[Markus Neteler]

Craig,

On Thu, Feb 14, 2008 at 4:04 PM, Craig Leat <Craig at pid.co.za> wrote:
>
>  Hi
>
>  I tried the following:
>  v.patch -a -e in=sewer_digit at sewer out=sewer_MN --overwrite
>  and received:
>  ERROR: Column names differ
>
>  The columns names don't differ, only the order differs:
>  v.db.connect -c sewer_MN
>  TEXT|comment
>  INTEGER|cat
>  TEXT|pipe_id
>  DOUBLE PRECISION|pipe_length_m
>  DOUBLE PRECISION|pipe_size_mm
>
>  and:
>  v.db.connect -c sewer_digit at sewer
>  INTEGER|cat
>  TEXT|comment
>  TEXT|pipe_id
>  DOUBLE PRECISION|pipe_length_m
>  DOUBLE PRECISION|pipe_size_mm
>
>  I'm using 6.3.0RC3, sqlite and sewer_digit is in a different mapset. If I
>  have to re-order the columns do you have any tips on how to do this?

Mhh, the column oder will be indeed the problem.
New columns are added to the right, but that's obviously annoying to
do manually.
It should be a general SQL join problem - any experts here?

Markus