Re: [GENERAL] FC13 RPMs for 9.0 - on postgresql.org ftp, but not in yum repo?

2010-09-06 Thread Joshua D. Drake
On Mon, 2010-09-06 at 09:22 +0300, Devrim GÜNDÜZ wrote: > > It seems that the FC13 PGDG RPMs appear here: > > > > http://www.postgresql.org/ftp/binary/v9.0rc1/linux/rpms/fedora/fedora-13-x86_64/ > > > > but not in the Yum repo on pgsqlrpms.org: > > > > http://yum.pgsqlrpms.org/9.0/fedora/ Sor

[GENERAL] PostgreSQL dblink's way of manipulation with connections

2010-09-06 Thread Piotr Rekowski
I have created the named dblink connection, then used db A to call simultaneously the same procedure twice on db B. I have noticed that the there is one open connection all the time, and there is second which appear and disappear continually. Is there a way to use connection pooling, so that one ca

Re: [GENERAL] Connection pool

2010-09-06 Thread Mark Gabriel Paylaga
Thanks! I'll look into it. On Mon, Sep 6, 2010 at 2:54 PM, Sergey Konoplev wrote: > Hi, > > On 6 September 2010 10:34, Mark Paylaga wrote: >> Hi sorry if this has been asked already. >> Is there any mechanism to do connection pooling for libpqxx already? >> Or any new developments for this? >> >

Re: [GENERAL] Temporal'sh type sql question

2010-09-06 Thread Angus Miller
Thanks Sergery that's what I was after. 1 2010/01/01 On Mon, Sep 6, 2010 at 2:29 PM, Sergey Konoplev wrote: > Hi, > > On 6 September 2010 16:18, Angus Miller wrote: >> How can I generate result-set that will carry the previous records >> values through till a new event occurred so there is a r

Re: [GENERAL] Temporal'sh type sql question

2010-09-06 Thread Sergey Konoplev
Hi, On 6 September 2010 16:18, Angus Miller wrote: > How can I generate result-set that will carry the previous records > values through till a new event occurred so there is a record for each > "day"? If I understand the problem correct you need to use generate_series() function (http://www.pos

[GENERAL] Temporal'sh type sql question

2010-09-06 Thread Angus Miller
Hi I have a table that models data in a temporal fashion. I say temporal fashion as I'm not sure I got this 100% right buy here goes. Basically each record has a date_from and date_to column. The date_from column always defaults to the current system date. The date_to column is either a far future

Re: [GENERAL] FC13 RPMs for 9.0 - on postgresql.org ftp, but not in yum repo?

2010-09-06 Thread Craig Ringer
On 06/09/10 16:26, Devrim GÜNDÜZ wrote: > On Mon, 2010-09-06 at 15:53 +0800, Craig Ringer wrote: >> >> ... so if yum.pgrpms.org is the new official host. > > It is not :) OK. Well, there are still no FC13 RPMs on the official yum repo - so I guess my question about why there are FC13 RPMs in offi

Re: [GENERAL] FC13 RPMs for 9.0 - on postgresql.org ftp, but not in yum repo?

2010-09-06 Thread Devrim GÜNDÜZ
On Mon, 2010-09-06 at 15:53 +0800, Craig Ringer wrote: > > ... so if yum.pgrpms.org is the new official host. It is not :) Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http://yum.pgrpms.org Community: devrim~PostgreSQL.org, dev

Re: [GENERAL] FC13 RPMs for 9.0 - on postgresql.org ftp, but not in yum repo?

2010-09-06 Thread Craig Ringer
On 06/09/10 14:22, Devrim GÜNDÜZ wrote: > On Sun, 2010-09-05 at 21:15 +0800, Craig Ringer wrote: >> >> I've been thinking of switching from using git builds of 9.0 to the >> RC >> now that it's out, so I can do some testing on the proposed release >> packaging. >> >> It seems that the FC13 PGDG R

Re: [GENERAL] Compiling extension C with MingW in windows, Error...

2010-09-06 Thread Magnus Hagander
On Fri, Sep 3, 2010 at 18:23, Edwin Quijada wrote: > >> Date: Fri, 3 Sep 2010 09:41:17 +0200 >> Subject: Re: [GENERAL] Compiling extension C with MingW in windows, >> Error... >> From: mag...@hagander.net >> To: listas_quij...@hotmail.com >> CC: pgsql-general@postgresql.org >> >> On Fri, Sep 3, 20