Re: [GENERAL] Static functions

2008-10-05 Thread Martijn van Oosterhout
On Sat, Oct 04, 2008 at 08:30:32PM -0400, Joseph S wrote: > In this case, with the function being called over and over again inside > a nested loop, it would be worth the effort. I'm not even talking about > caching the result for the whole transaction block, just replacing the > function call

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > I don't know of a way to make MD5 and db_user_namespace work cleanly so > we are considering removing db_user_namespace in 8.4. We are? It's no more or less ugly than the day it was put in (the MD5 encryption option was already there). If we had some i

Re: [GENERAL] db_user_namespace, md5 and changing passwords

2008-10-05 Thread Alvaro Herrera
Tom Lane escribió: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I don't know of a way to make MD5 and db_user_namespace work cleanly so > > we are considering removing db_user_namespace in 8.4. > > We are? It's no more or less ugly than the day it was put in (the > MD5 encryption option was al

[GENERAL] IP4r on windows

2008-10-05 Thread Kieran Seal
Is it possible to build the IP4r module for a windows postgres server? If so does anybody know how I would go about it? Otherwise, it would be great if somebody could post the precompiled .dll file for me. Thanks!

[GENERAL] GISVM - One Month old - Statistics Report

2008-10-05 Thread Ricardo Pinho
Dear all, GISVM is a month old and more than 2,000 downloads!!! For more information please read the "1st month statistics report" (BLOG) on: http://www.gisvm.com If you haven't done it, download it now and enjoy! Thank you. Regards, -- Ricardo Pinho Novos endereços, o Yahoo! que você

[GENERAL] GISVM - One Month old - Statistics Report

2008-10-05 Thread Ricardo Pinho
Dear all, GISVM is a month old and more than 2,000 downloads!!! For more information please read the "1st month statistics report" (BLOG) on: http://www.gisvm.com If you haven't done it, download it now and enjoy! Thank you. Regards, -- Ricardo Pinho Novos endereços, o Yahoo! que você

[GENERAL] General data warehousing questions

2008-10-05 Thread Sean Davis
I am looking at the prospect of building a data warehouse of genomic sequence data. The machine that produces the data adds about 300million rows per month in a central fact table and we will generally want the data to be "online". We don't need instantaneous queries, but we would be using the da

Re: [GENERAL] General data warehousing questions

2008-10-05 Thread Scott Marlowe
On Sun, Oct 5, 2008 at 7:48 PM, Sean Davis <[EMAIL PROTECTED]> wrote: > I am looking at the prospect of building a data warehouse of genomic > sequence data. The machine that produces the data adds about > 300million rows per month in a central fact table and we will > generally want the data to b