Re: [GENERAL] install problem

2004-10-09 Thread Bernard Clement
Dear Wayne, Hum! you are not following exactly the instructions for a "Short Installation" which is: ./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data /usr/local/pg

Re: [GENERAL] 7.5 Windows version

2004-06-22 Thread Bernard Clement
Hello Jonathan, Take look at URL: http://techer.pascal.free.fr/postgis/psqlwin/ That French guy has a binary version of PG for Windows. The zip is at URL: http://techer.pascal.free.fr/postgis/psqlwin.zip Note that I did not tried it! Good luck! Bernard On Tuesday 22 June 2004 15:13, Jonathan

Re: [GENERAL] [pgsql-advocacy] Best open source db poll currently

2004-03-31 Thread Bernard Clement
Done too :) Hum! IMHO not so many people because when I click PG went from 16% to 17% immediately. Bernard On Wednesday 31 March 2004 14:09, Marc G. Fournier wrote: > Done :) > > Guys ... poll now shows 53% for MaxDB (ie. MySQL) and 15% for PostgreSQL > ... think we can improve on that? :) > >

Re: [GENERAL] License on PostgreSQL

2004-03-26 Thread Bernard Clement
There is no license fee either for commercial or non commercial usage as state: " Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and th

Re: [GENERAL] returning row numbers in select

2004-03-10 Thread Bernard Clement
Maybe by using a sequence and a function. The sequece to generate the row number. The a function 1) to reset the sequence and 2) to perform a select with the first column nextval(seq) and the column the timestamp However, I am a newbie with PostgreSQL and I am not sure it this will work cor