PgSql

[HACKERS] Should database = all in pg_hba.conf match a replication connection?
I spent a fair amount of time just now being confused about why pg_hba.conf restrictions on replication connections didn't seem to be getting enforced. After looking at the code, I realize that my entry with database = "replication" was indeed getting rejected as not matching, but then the hba code was falling thr... 20 Apr 2010 19:41

[HACKERS] BETA
I think it might be time to think about shipping a beta release. I guess this is a -core decision, but I can't argue for it there, so I'll argue for it here. It seems like we're about ready, so maybe we could plan for a beta, say, a week from now? Here's a quick run-down of the remaining open items at http://w... 20 Apr 2010 18:32

Vacuum cancels autovacuum error message confusing?
Josh Berkus wrote: vacuum...ERROR: canceling autovacuum task CONTEXT: automatic analyze of table "bench.public.pgbench_accounts" ERROR: canceling autovacuum task CONTEXT: automatic analyze of table "bench.public.pgbench_accounts" done. What happened above is that the build of the new pgbench... 20 Apr 2010 21:54

BUG #4887: inclusion operator (@>)on tsqeries behaves not conforming to documentation
Robert Haas wrote: On Wed, Feb 24, 2010 at 2:11 PM, Bruce Momjian <bruce(a)momjian.us> wrote: Oleg, Teodor, would you look at this? ?I see the same behavior in 9.0. As there has been no movement on this I think we should punt this from: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items ... 20 Apr 2010 18:32

should I post the patch as committed?
Robert Haas <robertmhaas(a)gmail.com> writes: Bruce suggested to me off-list that when I commit a patch with revisions, I ought to attach the committed patch to the email in which I say that I have committed it. I know that Bruce habitually does this, but I've never found it very helpful, since I prefer to l... 23 Apr 2010 21:20

[HACKERS] Why does TRIM() expect an expr_list?
In gram.y, the productions for the TRIM() expression expect an argument of trim_list: TRIM '(' trim_list ')' TRIM '(' TRAILING trim_list ')' TRIM '(' LEADING trim_list ')' TRIM '(' BOTH trim_list ')' And trim_list is defined as: trim_list: a_expr FROM expr_list { $$ = lappend($3, $1); } | FR... 20 Apr 2010 18:32

SpinLockAcquire question
Boszormenyi Zoltan <zb(a)cybertec.at> writes: is there a danger in using SpinLockAcquire() in a signal handler? Yes. Actually, pretty much anything beyond setting a "volatile" flag variable is too dangerous. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To ... 20 Apr 2010 18:32

[HACKERS] SpinLockAcquire question
Hi, is there a danger in using SpinLockAcquire() in a signal handler? I mean if e.g. a spinlock is already taken by the process and a signal comes that's handler wants to execute SpinLockAcquire() again, does it lock up or simply increases the lock counter? Thanks in advance, Zolt�n B�sz�rm�nyi -- Bible... 20 Apr 2010 18:32

unresolved bugs
On Thu, Jan 7, 2010 at 11:55 AM, Magnus Hagander <magnus(a)hagander.net> wrote: BUG #5245: Full Server Certificate Chain Not Sent to client http://archives.postgresql.org/pgsql-bugs/2009-12/msg00145.php Not clear to me whether this is a bug, or at least our bug. It's not a  bug, it's potentially a... 20 Apr 2010 18:31

[HACKERS] Vacuum cancels autovacuum error message confusing?
All: NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_branches_pkey" for table "pgbench_branches" NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_tellers_pkey" for table "pgbench_tellers" NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbe... 20 Apr 2010 18:31