Re: [GENERAL] Re: importing into postgres from access

Alex Bolenok wrote: > > At 16:31 11/07/00 +0930, Stephen Davies wrote: > > >You can in fact access an Access database from Linux. > > > > > >Just install the Universal ODBC stuff from OpenLink > > > > URL please, neither openlink.com nor openlink.org seem to be the right > places. > > > > Thanks

[GENERAL] Building a library for PG

figuration: Configure.in Makefile.am aclocal.m4 acconfig.h Thanks. Franck Martin Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: http://www.sopac.org/ <http://www.sopac.org/> This e-ma

RE: [GENERAL] Using BLOBs with PostgreSQL

PG definitively lack BLOB support and it is a big drawback... Even with PG7.1 with TOAST that will remove the 8kB limit on records, there will be still no BLOB support. As you have indicated it seems that PG chokes on null characters. What is needed is a varbinary type, which stores binary data

[GENERAL] Indexing for geographic objects?

I'm building a new geo type and would like to index it. I have heard about RTREE and boundary box but I'm clueless for the moment about the implementation I have tried to look into PG source code to find the location where the indexing is done of current line object is done, but couldn't pin

[GENERAL] postgresql and Mandrake: no gist support?

I'm using Mandrake 7.2 and I cannot find the files gist.h and rtree.h in the postgres-devel rpm. Does anyone knows where are they ? Cheers. Franck Martin Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] Web site: http://www.sopa

[GENERAL] geoobj type

For the people interested, I have just commited in CVS of FMaps a new PostgreSQL type called geoobj. It is a very early release as I want to have early feedback. It is not complete and has many bugs, but it should give an overview of the type and the coding of it. It tries to follow the OpenGIS

[GENERAL] ISO SQL Geographic Objects

some examples of SQL representations. Thanks Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: http://www.sopac.org/ <http://www.sopac.org/> Support FMaps: http://fmap

RE: [GENERAL] GUI Interfaces

Check also gnomeDB on www.gnome.org go to office. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: http://www.sopac.org/ <http://www.sopac.org/> Support

[GENERAL] gmail screenshot...and Exchange server for linux?

ert it into the database. -Then you add some procedures and rules to the database, so that users can create custom rules to process the incoming messages. The result, you have created Exchange Server for Linux very quickly... Keep the good work. Cheers. Franck Martin [EMAIL PROTECTED]

RE: [GENERAL] GIS-type databases using PostgreSQL

to be rewritten as they are not ISO19100 compliant. But all the concepts are there and working. The work doesn't stop here and include metadata schema, feature schema, but a the moment the crunch is creating a geographic object type in PG and rendering it. Cheers. Franck Martin Networ

RE: [GENERAL] Oft Ask: How to contribute to PostgreSQL?

Does anybody know about some GIS or GPS software using PostgreSQL outside GRASS? Thanks. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: www.sopac.org.fj

[GENERAL] GIS and PostgreSQL ?

Does anybody know some GIS software used with PostgreSQL ? Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web site: www.sopac.org.fj <http://www.sopac.org.fj>

Max len record and how to access an array in binary

I would like to know the max length of a record containing arrays. How can I access the array field in binary form instead of ascii form. I'm using the pgsql library in C. Cheers. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission F

RE: [GENERAL] unique row identifier data type exhausted . . .

you will need a lot of record you may decide to use 1, 2, or 3 numbers... Question, does postgress is able to run sequence on 2 combined numbers... Cheers... Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED