PostGRASS is alive!

Dear GRASS Community,

some people might remember the Sequoia 2000 project. That
time an interface GRASS-Postgres was written. The last years
it was quite calm, but now we present the new

  PostGRASS project: GRASS gets an interface to PostgreSQL
  by Carl Anderson <candrsn@mindspring.com>

The current home for PostGRASS is:
  Bereich Geographie – Naturwissenschaftliche Fakultät – Leibniz Universität Hannover

Background: GRASS still lacks of a powerful interface
  to (free) database management systems. PostgreSQL
  (www.postgresql.org) is such an DBMS. PostGRASS shall
  be GRASS with an interface to this DBMS for direct
  accessing postgres data through GRASS modules
  (currently available: d.site.pg, d.vect.pg, g.select.pg,
  g.table.pg, d.what.s.pg).

We hope to find more people interested in extending this
interface!

Markus Neteler

Hi All,

Markus Neteler, is a bit over anxious for PostGRASS.

The project to interfaces Postgress and GRASS is ongoing and some
working modules do exist. But the code needs testing, some general interface
questions are being resolved, and other people are working on the interface.

What has been posted (as of 11/15) for user testing:
        d.site.pg
        d.vect.pg
        d.what.s.pg
        g.column.pg
        g.select.pg
        g.stats.pg
        g.table.pg
        text_functions.sql - needed for g.stats.pg
                                - should be in system functions but alas....
        
These modules are modifications to the Postgres / GRASS code offered by Markus
in September.

The posted modules are strictly for category support of GRASS datasets.
As such, I propose renaming the modules as follows (to make room for proper
spatial support):

        d.site.pg d.site.cat.pg
        d.rast.pg d.rast.cat.pg
        d.vect.pg d.vect.cat.pg

        d.what.s.pg d.what.s.cat.pg
        d.what.r.pg d.what.r.cat.pg
        d.what.v.pg d.what.v.cat.pg

        r.reclass.pg r.reclass.cat.pg
        r.rescale.pg r.rescale.cat.pg
        v.reclass.pg r.reclass.cat.pg

Please email your comments / votes.

----------------------------------
E-Mail: Carl Anderson <candrsn@mindspring.com>
Date: Mon, 15-Nov-98 12:00:00 +0000 (GMT)
Time: 22:20:18

This message was sent by XFMail
----------------------------------

On Nov 15, 10:39pm, Carl Anderson wrote:

Subject: RE: PostGRASS is alive!
The posted modules are strictly for category support of GRASS datasets.
As such, I propose renaming the modules as follows (to make room for proper
spatial support):

        d.site.pg d.site.cat.pg
        d.rast.pg d.rast.cat.pg
        d.vect.pg d.vect.cat.pg

        d.what.s.pg d.what.s.cat.pg
        d.what.r.pg d.what.r.cat.pg
        d.what.v.pg d.what.v.cat.pg

        r.reclass.pg r.reclass.cat.pg
        r.rescale.pg r.rescale.cat.pg
        v.reclass.pg r.reclass.cat.pg

Please email your comments / votes.

No objections from me for the name change.

--
Sincerely,

Jazzman (a.k.a. Justin Hickey) e-mail: jhickey@hpcc.nectec.or.th
High Performance Computing Center
National Electronics and Computer Technology Center (NECTEC)
Bangkok, Thailand

People who think they know everything are very irritating to those
of us who do. ---Anonymous

Jazz and Trek Rule!!!

  I am also supportive of the proposed name changes for the
postgresql- GRASS interface modules. I am glad to see that there has been
continued interest in the linking of these two wonderful softwares.

Which version of Postgresql has the recent work with interface been done?

Jeff P. Hollenbeck
Dept. of Forest Resources
Oregon State University
Corvallis, OR 97331
hollenbj@ucs.orst.edu

Some early code tas tested againt 6.3.2

but I have upgraded to 6.4 since (that is the current version)
6.4 adds a procedureal language and
I need that for some functions

Outside of the added functions every thing should work against 6.3.2

----------------------------------
E-Mail: Carl Anderson <candrsn@mindspring.com>
Date: Tue, 16-Nov-98 12:00:00 +0000 (GMT)
Time: 19:33:20

This message was sent by XFMail
----------------------------------

Hi, all
I have compiled the postgrass on linux RH5.1.
But it have Error Message: PG_HOST not set when I run g.select.pg or
g.table.pg ...
PG_HOST xxx.xxx.xxx.xxx or setenv PG_HOST pg_path both don't work.
How I should to set PG_HOST ??

BTW, I have change linux from Slackware to RH.
I used gmake4.2 to compile sources very well on Slackware, but
it seem be many errors after I install RH.
for examples:
OBJ.linux/label.o(.text+0x10b):the `gets' function is dangerous and
should not be used.
What's wrong?

Thanks for your help :slight_smile:

--

Der-Johng Sun djsun@gate.sinica.edu.tw
Init. Botany of Academia Sinica, Taiwan