[GRASSLIST:1817] Re: db.copy

GRASS GRASS user
1

On Monday 17 November 2003 16:19, Miha STAUT wrote:
> Hi,
>
> Why is the following command wrong? The opposite way works without problem.
>
> GRASS 5.7.0-cvs:/home/ines > db.copy from_driver=pg
> from_database=dbname=nuts\
> from_table=dejanja to_driver=dbf to_database=./ to_table=dej
> dbmi: Protocol error
> WARNING: Cannot create new table: 'create table dej ( ks_ime_d varchar(-5),
> 127 integer, 129 integer, 133 integer, 134 integer, 135 integer,
> 136
> integer, 137 integer, 143 integer, 144 integer, 145 integer, 152
> integer,
> 180 integer, 181 integer, 183 integer, 196 integer, 197 integer,
> 200
> integer, 201 integer, 202 integer, 203 integer, 211 integer, 212
> integer,
> 213 integer, 214 integer, 215 integer, 216 integer, 217 integer,
> 218
> integer, 221 integer, 224 integer, 226 integer, 228 integer, 245
> integer,
> 254 integer, 256 integer, 299 integer, 302 integer, 303 integer,
> 309
> integer, 310 integer, 311 integer, 317 integer, 327 integer, 333
> integer,
> vsa_dejanja integer, kriminalnost double precision)'
> Segmentation fault
>
> Or is there a command I could use to succesfully export a PostgreSQL table
> to a .dbf table?
>
> Thanks in advance, Miha Staut

What '\d dejanja' in psql says?

     Table "dejanja"
   Column | Type |
-------------+---------+-
ks_ime_ | text |
127 | integer |
129 | integer |
133 | integer |
134 | integer |
135 | integer |
136 | integer |
137 | integer |
143 | integer |
144 | integer |
145 | integer |
152 | integer |
180 | integer |
181 | integer |
183 | integer |
196 | integer |
197 | integer |
200 | integer |
201 | integer |
202 | integer |
203 | integer |
211 | integer |
212 | integer |
213 | integer |
214 | integer |
215 | integer |
216 | integer |
217 | integer |
218 | integer |
221 | integer |
224 | integer |
226 | integer |
228 | integer |
245 | integer |
254 | integer |
256 | integer |
299 | integer |
302 | integer |
303 | integer |
309 | integer |
310 | integer |
311 | integer |
317 | integer |
327 | integer |
333 | integer |
vsa_dejanja | integer |
kriminalnost| real |

BTW, from_database=nuts should be OK.

Radim

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

2

On Wednesday 19 November 2003 11:50, Miha STAUT wrote:

>On Monday 17 November 2003 16:19, Miha STAUT wrote:
> > Hi,
> >
> > Why is the following command wrong? The opposite way works without
>
>problem.
>
> > GRASS 5.7.0-cvs:/home/ines > db.copy from_driver=pg
> > from_database=dbname=nuts\
> > from_table=dejanja to_driver=dbf to_database=./ to_table=dej
> > dbmi: Protocol error
> > WARNING: Cannot create new table: 'create table dej ( ks_ime_d
>varchar(-5),
> > 127 integer, 129 integer, 133 integer, 134 integer, 135
>
>What '\d dejanja' in psql says?

     Table "dejanja"
   Column | Type |
-------------+---------+-
ks_ime_ | text |
127 | integer |

There are 2 problems in this case,

1) type 'text' is not supported by pg driver, recently you should get a warning:
WARNING: pg driver: column 'ks_ime_', type 0 is not supported

2) dbf driver doesn't support column names beginning with a digit,
   in fact until today, I did not know that postgres does, also
   Postgres manual says "SQL identifiers and key words must begin
   with a letter (a-z) or underscore (_)."

Radim

3

Hi everybody,

    Well, I have created binaries for GRASS 5.0.3, and it is working well
on my Suse 9.0.
    But how Suse uses Tcl and Tk 8.4, NVIZ will not work with Red Hat, because
it uses 8.3 (I know this because I tested, I also try to create links for libtcl8.3.so and
libtk8.3.so, but it doesn't work too).
    I think that this binaries will work well with the distributions that come with
Tcl and Tk 8.4 like Mandrake and Suse.
    It was compiled with this:

System:
i686-pc-linux-gnu, compiled with:
Including precompiled library for r.in.gdal
Configured with: ../configure --enable-threads=posix --prefix=/usr --with-local-prefix=/usr/local --infodir=/usr/share/info --mandir=/usr/share/man --libdir=/usr/lib --enable-languages=c,c++,f77,objc,java,ada --disable-checking --enable-libgcj --with-gxx-include-dir=/usr/include/g++ --with-slibdir=/lib --with-system-zlib --enable-shared --enable-__cxa_atexit i586-suse-linux
Thread model: posix
gcc version 3.3.1 (SuSE Linux)

    My machine is a Atlhon 2200, with 512 Mb RAM and Suse 9.0.
    Well, I dont have a server to put my binaries, can I upload it to the ftp on
grass.itc.it??
    Cheers.

--
Oceanographer Christian dos Santos Ferreira
Lab. of Fisheries Reaserch and Hydroacoustics
Departament of Oceanography
Federal University of Rio Grande (FURG)
Av. Italia km 8 s/n - Campus Carreiros
Caixa Postal 474 - CEP 96203-000
Rio Grande - RS - Brazil
Phone: (53) 233-6528 - Fax: (53) 233-6601

"Open source:...
  
    ...Millions of open minds can't be wrong."