PgSql

lexeme ordering in tsvector
Sushant Sinha <sushant354(a)gmail.com> writes: Was this change in ordering deliberate? Yes. Wouldn't length comparison be cheaper than memcmp? It's not just about "cheapest" anymore, it also has to support prefix operations. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers... 30 Nov 2009 13:36

[PATCH] hstore documentation update
Applied. Thanks. --------------------------------------------------------------------------- David E. Wheeler wrote: From: David E. Wheeler <david(a)justatheory.com> As I threatened when I reviewed hstore in the last two commit fests, I've finally seen may way to edit the documentation. This is m... 30 Nov 2009 13:36

Application name patch - v4
Dave Page <dpage(a)pgadmin.org> writes: Updated application name patch, including a GUC assign hook to clean the application name of any unsafe characters, per discussion. Applied with assorted editorialization. There were a couple of definitional issues that I don't recall if we had consensus on: 1. The pa... 2 Dec 2009 10:59

Backup history file should be replicated in Streaming Replication?
Fujii Masao wrote: On Thu, Nov 26, 2009 at 4:55 PM, Heikki Linnakangas <heikki.linnakangas(a)enterprisedb.com> wrote: Fujii Masao wrote: In current SR, since a backup history file is not replicated, the standby always starts an archive recovery without a backup history file, and a wrong minRecove... 4 Jan 2010 08:08

[PATCH 4/4] Add tests to dblink covering use of COPY TO FUNCTION
On Mon, Nov 23, 2009 at 4:34 PM, Daniel Farina <dfarina(a)truviso.com> wrote: Signed-off-by: Daniel Farina <dfarina(a)truviso.com> Thanks for the patch. You may want to take a look at this: http://wiki.postgresql.org/wiki/Submitting_a_Patch I'm fuzzy on what problem this is attempting to solve... as mentioned... 30 Dec 2009 01:11

[HACKERS] [PATCH 1/4] Add "COPY ... TO FUNCTION ..." support
This relatively small change enables all sort of new and shiny evil by allowing specification of a function to COPY that accepts each produced row's content in turn. The function must accept a single INTERNAL-type argument, which is actually of the type StringInfo. Patch highlights: - Grammar production cha... 23 Nov 2009 17:31

pgsql: Add a WHEN clause to CREATE TRIGGER, allowing a boolean
On Fri, Nov 20, 2009 at 3:38 PM, Tom Lane <tgl(a)postgresql.org> wrote: Log Message: ----------- Add a WHEN clause to CREATE TRIGGER, allowing a boolean expression to be checked to determine whether the trigger should be fired. For BEFORE triggers this is mostly a matter of spec compliance; but for AFTE... 20 Nov 2009 17:58

plruby code and postgres ?
On Thu, Nov 19, 2009 at 05:15:05PM -0700, u235sentinel wrote: Does anyone have a link for pl/ruby? I found a link under the postgres documentation and found a web site from there talking about the code. However when I clicked on the link to download it I noticed ftp wouldn't respond on their site. D... 20 Nov 2009 12:20

Question about ECPGset_noind_null() and ECPGis_noind_null()
Boszormenyi Zoltan �rta: Hi, my question is that what platform were these functions developed and tested? We have come across a value that fails a NOT NULL constraint upon INSERT under HP-UX/IA64, but not under x86-64 Linux. The value in question is 1.9999999999999998 assigned to a "double" v... 19 Nov 2009 16:21

Oversight in CREATE FUNCTION + EXPLAIN?
"Joshua D. Drake" <jd(a)commandprompt.com> writes: Shouldn't the estimated rows be 50? It is if you do "select * from return_lots(10000000)". regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/... 18 Nov 2009 17:59