Re: [GENERAL] Re: [ANNOUNCE] Request for speakers at O'Reilly conference

2001-02-16 Thread selkovjr
Bruce Momjian wrote: > Interesting. I think GIST itself may be too specific for a talk. > However, type extensibility would be very interesting. As it turns out, there are just two am's one will most likely build new types upon: btree and GiST. A useful tutorial should include examples of both,

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

2000-12-03 Thread selkovjr
Franck Martin wrote: > I have already created geographical objects which contains MBR(Minimum > Bounding Rectangle) in their structure, so it is a question of rewriting > your code to change the access to the cube structure to the MBR structure > inside my geoobject. (cf http://fmaps.sourceforge.n

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

2000-11-30 Thread selkovjr
the current version of regression tests for the data types that depend on it. One can find them in my contrib directory, under test/ (again, it's http://wit.mcs.anl.gov/~selkovjr/pg_extensions/contrib.tgz) It would be nice if at least one of the GiST types became a built-in (that would provide for

[GENERAL] Re: [HACKERS] Indexing for geographic objects?

2000-11-27 Thread selkovjr
Tom Lane wrote: > Do you have any problem with releasing your stuff under the Postgres > distribution terms (BSD license)? No, I don't see any problem with the BSD license, or any other license, for that matter. I just had some reservations about releasing stuff that was far from perfect, and it

Re: [GENERAL] responses to licensing discussion

2000-07-05 Thread selkovjr
Jan Wieck wrote: > I'm in doubt why none of the other open source projects ever > felt the need to enforce license agreement in this way while > most commercial players do. Maybe it's something we don't > have to worry about, but what if so? What if we all have > a

Re: [GENERAL] Re: [ANNOUNCE] Re: [HACKERS] proposed improvements to PostgreSQL license

2000-07-05 Thread selkovjr
Simon Brooke wrote: > Ned Lilly wrote: > > > > > Two states have adopted UCITA - Virginia and Maryland. Maryland has > > > an October 1, 2000, effective date, but requires that its laws will > > > only apply if there is a reasonable connection with the state. > > > Virginia has an effective dat

Re: [GENERAL] Help: How to store query output in a file !!!

2000-06-14 Thread selkovjr
> > Does anyone knows how do you send query output to a file??? Welcome to Unix(TM): psql -c "select * from , etc." > See also: http://www.isu.edu/departments/comcom/unix/workshop/io.html or, type "unix tutorial" in any web search engine. --Gene > I tried following but it does not work:

Re: [GENERAL] Size Limit

2000-06-14 Thread selkovjr
> Sir, > > I am currently using ingres and would like to migrate to postgres. > However the problem is that my existing database is now over 2GB and all of > my scsi disks are only at 2GB. In ingres all I have to do to extend large > tables to multiple locations or file systems (disks) there

Re: [GENERAL] problems with memory

2000-02-18 Thread selkovjr
> * Dean Browett <[EMAIL PROTECTED]> [000218 15:55] wrote: > > Hi, > > > > We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under > > Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb > > network and the nics are 3com3c590's. We are also using a DPT

Re: [GENERAL] Geometric, getting x and y co-ordinates GOING MAD!!!!!

1999-06-04 Thread selkovjr
> I have no training in C so I've reached this far by trial and error. I > have however discovered that if write a function such as > > /* pants.c >weird of what! */ > #include "postgres.h" > #include "utils/geo_decls.h" > double > pants(Point *pt) > { > return 2.0; > } > > and compil

Re: [GENERAL] Trying to make functions in 'C'

1999-05-16 Thread selkovjr
> I'm tying to learn how to make function in 'C'. > I'm trying to compile a program I made in 'C'. > The command I gave were: > > % gcc -fPIC -c addone.c -I/usr/local/pgsql/include > % ld -G -Bdynamic -o addone.so addone.o > > and created the function in postgres like this: > > CREATE