PgSql

[HACKERS] Cstring vs. Datum values ( BuildTupleFromCStrings vs.BlessTupleDesc)
Hi, I'm trying to write a couple of C function that will: - return a tsvector as a set of record. - turn a tsvector into a tsquery I'm looking at the example function to return set of records http://www.postgresql.org/docs/8.4/static/xfunc-c.html#AEN44970 and to this: "There are two ways you can build a co... 23 Jan 2010 08:44

[HACKERS] Improving the accuracy of estimate_num_groups()
I was just poking at the test case provided by Allen Johnson in bug #5294. The essence of the complaint is that the planner is choosing a sort-and-GroupAggregate plan when a HashAggregate-and-then-sort plan would be faster, because the aggregation steps are roughly the same speed either way while post-aggregation ... 23 Jan 2010 00:08

psql tab completion recently broken?
"Kevin Grittner" <Kevin.Grittner(a)wicourts.gov> wrote: I just updated my source code and it no longer seems to work to type the following, and I'm pretty sure I was using it with a checkout from less than 24 hours ago: Never mind. My mistake. -Kevin -- Sent via pgsql-hackers mailing list (pgsql-ha... 22 Jan 2010 12:57

plpythonu DO support (inline call handler)
On tis, 2009-11-17 at 18:48 +0200, Valtonen, Hannu wrote: The attached patch adds support for DO clause in plpythonu. It was heavily inspired by the plperl and plpgsql inline handler code. committed -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscri... 22 Jan 2010 11:48

Standby server lagging behind
"Huda Booley (huda(a)careerjunction.co.za)" <Huda(a)careerjunction.co.za> wrote: These get copied to the standby so its all there, just not being applied fast enough. If the files are there and are not applying fast enough, it's probably because on the source machine you can have multiple connections submit... 22 Jan 2010 11:48

Access to dynamic SQL in PL/pgSQL
2010/1/22 Simon Riggs <simon(a)2ndquadrant.com>: It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type, evaluate the SQL and free memory again before the plugin gain... 22 Jan 2010 12:57

[HACKERS] Access to dynamic SQL in PL/pgSQL
It's not currently possible to access the SQL used in a dynamic PL/pgSQL statement using a PL/pgSQL plugin. In src/pl/plpgsql/src/pl_exec.c's exec_stmt() we call each dynamic statement type, evaluate the SQL and free memory again before the plugin gains control again. It seems simple to attach querystr to PL... 22 Jan 2010 06:12

[HACKERS] warn in plperl logs as... NOTICE??
Why does warn; in plperl log as NOTICE in Postgres? On a related note, what's the logic behind perl DEBUG logging as DEBUG2 instead of DEBUG1 or DEBUG5? Still seems kind of odd, but at least nowhere near as surprising as warn becoming NOTICE... -- Jim C. Nasby, Database Architect jim(a)nasby.net 5... 21 Jan 2010 19:11

primary key error message
On Thu, Jan 21, 2010 at 3:30 PM, Peter Eisentraut <peter_e(a)gmx.net> wrote: Here is a small patch that changes the error message    duplicate key value violates unique constraint "%s" into    duplicate key value violates primary key "%s" when the constraint is in fact a primary key. Comm... 22 Jan 2010 10:39

[HACKERS] primary key error message
Here is a small patch that changes the error message duplicate key value violates unique constraint "%s" into duplicate key value violates primary key "%s" when the constraint is in fact a primary key. Comments? PS: Yes, this would need a handful of regression test updates if accepted. ... 21 Jan 2010 15:45