PgSql

[HACKERS] PGCon 2010 - registered yet?
Registration for PGCon 2010 is open. http://www.pgcon.org/2010/registration.php The full list of talks and a preliminary schedule is available here: http://www.pgcon.org/2010/schedule/ There are still some rooms available on campus but I recommend booking soon as they always fill up. -- Dan Lang... 24 Apr 2010 09:25

[HACKERS] Issue with ReRaise in PG
Hi, Please consider the following test case CREATE OR REPLACE FUNCTION raisetest() returns void AS $$ BEGIN BEGIN RAISE syntax_error; EXCEPTION WHEN syntax_error THEN BEGIN raise notice 'exception thrown in inner block, reraising'; RAISE; ... 24 Apr 2010 07:12

[HACKERS] why do we have rd_istemp?
Given "Relation rel", it looks to me like rel->rd_rel->relistemp will always give the same answer as rel->rd_istemp. So why have both? ....Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers ... 24 Apr 2010 05:02

pgsql: Add missing optimizer hooks for functioncost and number of rows.
On Fri, 2010-04-23 at 18:55 -0400, Tom Lane wrote: sriggs(a)postgresql.org (Simon Riggs) writes: Log Message: ----------- Add missing optimizer hooks for function cost and number of rows. Closely follow design of other optimizer hooks: if hook exists retrieve value from plugin; if still not se... 24 Apr 2010 03:57

recovery_connections cannot start (was Re: [HACKERS] master in standby mode croaks)
On Sat, Apr 17, 2010 at 6:52 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: On Sat, Apr 17, 2010 at 6:41 PM, Simon Riggs <simon(a)2ndquadrant.com> wrote: On Sat, 2010-04-17 at 17:44 -0400, Robert Haas wrote: I will change the error message. I gave a good deal of thought to trying to figure out... 26 Apr 2010 16:05

[HACKERS] CIText and pattern_ops
Is there any particular reason why the citext module doesn't have citext_pattern_ops operator family? Specifically, I wish to index for this type of query: .... WHERE citext_column LIKE 'Foo%'; This, of course, is equivalent to ILIKE 'Foo%' which does not appear to be indexable without using a functional ind... 24 Apr 2010 00:26

global temporary tables
Robert Haas <robertmhaas(a)gmail.com> writes: A couple of recent threads made got me thinking again about the idea of global temporary tables. There seem to be two principal issues: 1. What is a global temporary table? 2. How could we implement that? Despite rereading the "idea: global temp tables" ... 26 Apr 2010 17:13

[HACKERS] global temporary tables
A couple of recent threads made got me thinking again about the idea of global temporary tables. There seem to be two principal issues: 1. What is a global temporary table? 2. How could we implement that? Despite rereading the "idea: global temp tables" thread from April 2009 in some detail, I was not able ... 23 Apr 2010 23:19

Hot Standby b-tree delete records review
Simon Riggs wrote: On Thu, 2010-04-22 at 10:24 +0300, Heikki Linnakangas wrote: btree_redo: /* * Note that if all heap tuples were LP_DEAD then we will be * returning InvalidTransactionId here. This seems very unlikely * in practice. */ If none of the removed heap tuples wer... 23 Apr 2010 23:19

vcregress.bat check triggered Heap error in the Debugversionof win32 build
Xiong He wrote: Thanks. In my test, it fails during the vcregress.bat check startup. It's a Debug Assertion Error. File: dbgheap.c Line: 1252. E:\learn\db_research\postgreSQL\cvsroot\pgsql.latest\src\tools\msvc>vcregress.ba t check No test can run. I used VS2005 for the build. ... 24 Apr 2010 05:02