PgSql

[HACKERS] Error with GIT Repository
Greetings all, I have been trying to create/run a build farm as part of a project I am working on. However, I have noticed the primary git repostitory, git.postgresql.org/git, does not seem to be working. Namely, whenever I try to clone the directory, I receive this error: Error: Unable to find 5e4933c31d3cd27... 10 Jun 2010 14:33

Error with GIT Repository
Luxenberg, Scott I. wrote: Greetings all, I have been trying to create/run a build farm as part of a project I am working on. That seems an odd thing to do since we have one ... However, I have noticed the primary git repostitory, git.postgresql.org/git, does not seem to be working. Namely, ... 30 Jun 2010 18:42

[PERFORM] No hash join across partitioned tables?
(moving to -hackers) On Wed, Jun 9, 2010 at 4:11 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Robert Haas <robertmhaas(a)gmail.com> writes: In going back through emails I had marked as possibly needing another look before 9.0 is released, I came across this issue again. �As I understand it, analyze (or analy... 15 Jun 2010 15:24

variable TriggerFile can be declared as static
On 10/06/10 10:25, Fujii Masao wrote: Currently the variable TriggerFile is declared as extern, but it's not used in other source file than xlog.c. How about declaring it as static? Here is the patch. Thanks, applied. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent ... 10 Jun 2010 04:32

[HACKERS] variable TriggerFile can be declared as static
Hi, Currently the variable TriggerFile is declared as extern, but it's not used in other source file than xlog.c. How about declaring it as static? Here is the patch. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center ... 10 Jun 2010 03:27

[HACKERS] fix use of posix_fadvise in xlog.c
Hi all, I wanted to propose a fix for to xlog.c regarding the use of posix_fadvise() for 9.1 (unless someone feels it's ok for 9.0). Currently posix_fadvise() is used right before a log file is closed so it's effectively not doing anything, when posix_fadvise is to be called. This patch moves the posix_fadvise(... 10 Jun 2010 00:12

InvalidXLogRecPtr in docs
On Wed, Jun 9, 2010 at 9:46 PM, Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> wrote: I found a term "InvalidXLogRecPtr" in 9.0 docs. http://developer.postgresql.org/pgdocs/postgres/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE | ... then the return value will be InvalidXLogRecPtr (0/0). I think... 16 Jun 2010 22:08

[HACKERS] InvalidXLogRecPtr in docs
I found a term "InvalidXLogRecPtr" in 9.0 docs. http://developer.postgresql.org/pgdocs/postgres/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE | ... then the return value will be InvalidXLogRecPtr (0/0). I think it should not appear in docs because it's a name for an internal constant variable. I'd like to r... 9 Jun 2010 22:01

[HACKERS] 'create or replace function' no longer allows parameters
In 8.4.4 I used to be able to rename input parameters via "create or replace function". In 9.0 beta2 this no longer is allowed, and I get a descriptive message informing me to use drop function instead, but I couldn't find this documented anywhere as a change between 8.4 and 9.0. -------------- test=# CREATE... 9 Jun 2010 22:01

parser handling of large object OIDs
On Wed, Jun 9, 2010 at 5:02 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: I believe that the comment code is probably right, because I think IConst can only handle values < 2^31, whereas OIDs can be as large as 2^32-1. I investigated this a little more and the above analysis turns out to be correct. ALTE... 10 Jun 2010 07:47