[GENERAL] How can I make a two arch libpq for snow leopard?

2009-09-19 Thread Jerry LeVan
Hi, I have a i386 version of postgresql 8.4.1 created by setting export CC="gcc -arch i386" an then doing the config, make and make install. In particular libpq is an i386 library. Now I use two database 'adaptors' psycopg2 for python and pgtcl-ng for tcl. The python I use is from python.or

Re: [GENERAL] SIGSEGV when trying to start in single user mode

2009-09-19 Thread Björn Häuser
Hello Tom, thank you for your help. I resetted the xlog and the server started again. Regards, Björn 2009/9/19 Tom Lane : > =?UTF-8?B?QmrDtnJuIEjDpHVzZXI=?= writes: >> I have a problem with my PostgreSQL 8.3.4 installation. > >> We had some problems with our storage subsystem and it seems >> p

Re: [GENERAL] SIGSEGV when trying to start in single user mode

2009-09-19 Thread Tom Lane
=?UTF-8?B?QmrDtnJuIEjDpHVzZXI=?= writes: > I have a problem with my PostgreSQL 8.3.4 installation. > We had some problems with our storage subsystem and it seems > postgresql suffered a little bit from it. > Here are some log excerpts: > # /etc/init.d/postgresql-8.3 start > Starting PostgreSQL 8

Re: [GENERAL] haversine formula with postgreSQL

2009-09-19 Thread Tom Lane
Rob Wultsch writes: > On Thu, Sep 17, 2009 at 2:47 PM, Tom Lane wrote: >> Jonathan writes: >>> Here is my PHP with SQL: >>> $query = sprintf("SELECT 'ID', 'FACILITY', 'ADDRESS', latitude, >>> longitude, ( 3959 * acos( cos( radians('%s') ) * cos( radians >>> ( latitude ) ) * cos( radians( longitu

Re: [GENERAL] haversine formula with postgreSQL

2009-09-19 Thread Rob Wultsch
On Thu, Sep 17, 2009 at 2:47 PM, Tom Lane wrote: > Jonathan writes: > > Here is my PHP with SQL: > > $query = sprintf("SELECT 'ID', 'FACILITY', 'ADDRESS', latitude, > > longitude, ( 3959 * acos( cos( radians('%s') ) * cos( radians > > ( latitude ) ) * cos( radians( longitude ) - radians('%s') )

[GENERAL] SIGSEGV when trying to start in single user mode

2009-09-19 Thread Björn Häuser
Hello List, I have a problem with my PostgreSQL 8.3.4 installation. We had some problems with our storage subsystem and it seems postgresql suffered a little bit from it. Here are some log excerpts: When trying to start postgesql: --- # /etc/init.d/postgresql-8.3 start Starting PostgreSQL 8.3 da

Re: Re[GENERAL] garding initdb & pg_ctl

2009-09-19 Thread Inigo Barandiaran
Hi Chirs. Thanks for your Answer. We've already tried this method with Xp, and Vista and worked correctly in both, but We did no try with all versions as you did, so your help is very very appreciated. Thanks :) I'm sorry I can not help you because we have not 2003 server, and We can not do any te

Re: [GENERAL] Return 30% of results?

2009-09-19 Thread Merlin Moncure
On Sat, Sep 19, 2009 at 3:27 AM, nick wrote: > On Sep 18, 3:40 pm, spam_ea...@gmx.net (Thomas Kellerer) wrote: >> Nick wrote on 18.09.2009 23:31:> Is there a way to return a percentage of >> the rows found? I tried >> > window functions but get an error... >> >> > ERROR:  syntax error at or near

[GENERAL] The best agile methods and open source books

2009-09-19 Thread Dirk Riehle
Hi, I'm currently preparing a lecture on "agile and open source software development"; with the help of friends I created a list of "best" books on the topic. I'd like to hear your opinion. Which books do you know? Which are actually any good? Please take the survey here: http://www.surveymonke

[GENERAL] Open Positions in Ph.D. Studies in Open Source at the University of Erlangen, Germany

2009-09-19 Thread Dirk Riehle
The Open Source Research group at the Friedrich-Alexander-University of Erlangen-Nuremberg is seeking to hire recent graduates or experienced software developers to start doctoral studies immediately. We have several open positions. The main research topic are open source software engineering pro

Re: [GENERAL] Return 30% of results?

2009-09-19 Thread David Fetter
On Sat, Sep 19, 2009 at 12:27:10AM -0700, nick wrote: > On Sep 18, 3:40 pm, spam_ea...@gmx.net (Thomas Kellerer) wrote: > > Nick wrote on 18.09.2009 23:31:> Is there a way to return a percentage of > > the rows found? I tried > > > window functions but get an error... > > > > > ERROR:  syntax erro

Re: [GENERAL] haversine formula with postgreSQL

2009-09-19 Thread Merlin Moncure
On Fri, Sep 18, 2009 at 5:50 PM, Scott Bailey wrote: >> And I think that might work for you.  The performance is going to be >> miserable for large stat sets, because it's going to scan the whole >> aaafacilities table every time and recompute every distance, but as an >> example goes it's probabl

Re: [GENERAL] Return 30% of results?

2009-09-19 Thread nick
On Sep 18, 3:40 pm, spam_ea...@gmx.net (Thomas Kellerer) wrote: > Nick wrote on 18.09.2009 23:31:> Is there a way to return a percentage of the > rows found? I tried > > window functions but get an error... > > > ERROR:  syntax error at or near "OVER" > > > SELECT id, cume_dist FROM ( > >   SELECT

Re: Re[GENERAL] garding initdb & pg_ctl

2009-09-19 Thread chris_watcher
We are having exactly the same problem. It happens ONLY on Windows Server 2003 (any edition) It works great on the following Windows: Windows 2000(any),XP(any),Vista(any), Windows Server 2008, Windows 7 As you can see from the list above, we did guite a lot of testing Any input is appretiated.

Re: [GENERAL] Does PG cache results of an aggregate function, (and results of non-volatile functions)?

2009-09-19 Thread 纪晓曦
Well I don't think the result would keep if you run a "hot" test. However, in one SELECT clause, maybe it can be optimised . 2009/9/3 Allan Kamau > Hi, > I do have a query which make use of the results of an aggregate > function (for example bit_or) several times in the output column list > of