PgSql

[HACKERS] keep ppport.h in sync on all branches
Some recent off-list discussion has suggested that we should keep plperl's copy of ppport.h in sync on all branches, just as we do with timezone data files. So when we update it on HEAD we should simultaneously update the back branches. It's a derived file, produced by the perl module Devel::PPPort, so there ... 30 Mar 2010 09:25

UUIDs generated using ossp-uuid on windows not unique
On Tue, Jun 17, 2008 at 11:17 AM, Hiroshi Saito <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp> wrote: Hi. Please this. http://winpg.jp/~saito/pg_work/OSSP_win32/msvc/ Ahh, a makefile - that makes things somewhat clearer :-) Thanks - I've updated the build machine so future releases will incl... 31 Mar 2010 03:18

pending patch: Re: [HACKERS] Streaming replication and pg_xlogfile_name()
On Wed, Mar 3, 2010 at 11:03 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: On Tue, Mar 2, 2010 at 10:52 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: It's not clear what it should return, a TLI corresponding the filename of the WAL segment the record was replayed from, so that you can use pg_xlogfil... 6 Apr 2010 22:04

pending patch: Re: [HACKERS] HS/SR and smart shutdown
On Mon, Feb 1, 2010 at 11:49 AM, Fujii Masao <masao.fujii(a)gmail.com> wrote: On Sat, Jan 30, 2010 at 12:54 PM, Fujii Masao <masao.fujii(a)gmail.com> wrote: HOWEVER, I do believe this is an issue we could live with for 9.0 if it's going to lead to a whole lot of additional debugging of SR.  But if it's an... 13 Apr 2010 10:34

[HACKERS] I am interested in the MERGE command implementation as my gSoC project
To whom may concern, My name is Zhai Boxuan, a student from China. I am now a Master Student of National University of Singapore. And, before I came to Singapore, I have got another master degree in Wuhan University. In that period, I focus mainly on implementing a novel Object-oriented database model on the p... 30 Mar 2010 03:58

proposal - structured funcid and lineno as new fields in error message
Pavel Stehule <pavel.stehule(a)gmail.com> writes: can we add well structured information about function id and lineno to ErrorData? The idea that I was toying with was to report the function OID and line number, which might as well be two separate fields rather than messing around with anything "structured". ... 29 Mar 2010 13:37

[HACKERS] psql: edit function, show function commands patch
Hello this simple patch allow to specify cursor row when some function is opened in editor. \e aaa.txt \a aaa.txt 3 ... move cursor on 3nd line of text \ef foo \ef foo 3 ... move cursor on 3nd line of function body \sf foo ... show function body \sf+ foo ... show function body - use line numbers \sf[+] foo... 29 Mar 2010 12:29

[HACKERS] Parallel pg_dump for 9.1
People have been talking about a parallel version of pg_dump a few times already. I have been working on some proof-of-concept code for this feature every now and then and I am planning to contribute this for 9.1. There are two main issues with a parallel version of pg_dump: The first one is that it requires a... 29 Mar 2010 11:21

Using HStore type in TSearch
=?ISO-8859-2?Q?=A3ukasz_Dejneka?= <l.dejneka(a)gmail.com> writes: What I want to do is to use HStore data type (namely the HStore keys) in TSearch. I don't want use TSVector and the original ts_match_vq function, because I want to be able to control exact values that are passed to the search and not use their... 29 Mar 2010 13:37

enable_joinremoval
On Mon, Mar 29, 2010 at 4:33 AM, Simon Riggs <simon(a)2ndquadrant.com> wrote: We have planner method parameters for many important parts of the planner. We don't have any parameter for join removal, AFAIK. The first question I get asked is "can I see the tables it removed?". This has been asked of me 3 ... 29 Mar 2010 18:06