PgSql

psql \? \daS
On Wed, May 26, 2010 at 1:59 PM, Stephen Frost <sfrost(a)snowman.net> wrote:  Noticed this while playing around with psql regression tests. Good catch. It looks like the + option doesn't actually do anything for \da, though, so I'm inclined to just write \da[S] rather than \da[S+] (see: \dl, \dC). -- Robert... 26 May 2010 15:49

[HACKERS] Fwd: Re: [BUGS] dividing money by money
Hi Andy, Do you want to package this up as a patch for 9.1? If not, is it OK if I do? -Kevin Andy Balholm <andy(a)balholm.com> wrote: On Apr 1, 2010, at 7:57 AM, Kevin Grittner wrote: I'm inclined to think it's better to have an explicit cast from money to numeric, as long as it is exact, and ... 26 May 2010 14:42

[HACKERS] psql \? \daS
Greetings, Noticed this while playing around with psql regression tests. Thanks, Stephen commit 31bf61bab77ad991f2a67a41699384e57c021508 Author: Stephen Frost <sfrost(a)snowman.net> Date: Wed May 26 13:51:27 2010 -0400 Add 'S' to optional parameters for \da \da supports \daS, \da+... 26 May 2010 14:42

WIP patch for serializable transactions with predicate locking
On Wed, May 19, 2010 at 5:37 PM, Kevin Grittner <Kevin.Grittner(a)wicourts.gov> wrote: I heard that others were considering work on predicate locks for 9.1. Since Dan Ports of MIT and I have been working on that for the serializable implementation for the last few weeks, I felt it would be good to post a WIP... 26 May 2010 14:42

[PATCH] Add XMLEXISTS function from the SQL/XMLstandard
On ons, 2010-05-26 at 11:47 +0100, Mike Fowler wrote: The XMLEXISTS function works with XQuery expressions and doesn't have the call signature that your patch implements Looking at the manuals of Oracle, Derby and DB2 I see how the call signature differs. I also note that Oracle's implementation is... 1 Jun 2010 13:05

Show schema name on REINDEX DATABASE
On Mon, Apr 5, 2010 at 9:29 AM, Greg Sabino Mullane <greg(a)turnstep.com> wrote: Patch attached to show the schema *and* table name when doing a REINDEX DATABASE. Is this something that can be added to 9.1 commitfest? -selena -- http://chesnok.com/daily - me -- Sent via pgsql-hackers mailing list (p... 31 May 2010 20:46

libpq should not be using SSL_CTX_set_client_cert_cb
On Tue, May 25, 2010 at 10:29:07PM -0400, Tom Lane wrote: I've been experimenting with SSL setups involving chains of CA certificates, ie, where the server or client cert itself is signed by an intermediate CA rather than a trusted root CA. This appears to work well enough on the server side if you configu... 26 May 2010 23:32

[HACKERS] out-of-date comment in CreateRestartPoint()
This comment obviously requires adjustment now that HS is committed. The obvious way to change it is to replace "when we get hot standby capability" with "when running in Hot Standby mode", but I'm not clear whether that's all that's required. /* * If the last checkpoint record we've replayed is... 26 May 2010 10:15

[PATCH] Add XMLEXISTS function from the SQL/XMLstandard (was: Add xpath_exists Function)
On tis, 2010-05-25 at 15:31 +0100, Mike Fowler wrote: I've been reading the SQL/XML standard and discovered that it defines a function named XMLEXISTS that does exactly what the todo item xpath_exists defines. My original patch named the function as per the todo but I think using the function name from t... 26 May 2010 06:58

[HACKERS] Open items related to SR
Hi, Many open items related to SR are listed on the wiki again. http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items I clarify the status of those items. Smart shutdown gets stuck - patch to fix from Fuji Masao Robert is reviewing and testing the patch I submitted. I believe that the patch will be ... 26 May 2010 04:49