PgSql

plpythonu DO support (inline call handler)
Valtonen, Hannu wrote: I couldn't figure out how to get added files to show in git diff ... git add <new files> git add -u # to include modified files in the index git diff --cached -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hack... 17 Nov 2009 12:54

sgml and "empty" closing tags
Alex Hunsaker <badalex(a)gmail.com> writes: While looking over the writable cte patch I noticed queries.sgml has lots of things in the form "<literal>FROM</>". I tried various googles to see if </> is some kind of sgml/xml shorthand for close the last opened tag. But alas, nothing found. Bad google foo? ... 17 Nov 2009 20:51

[HACKERS] ORDER BY vs. volatile functions
This query: select random() from generate_series(1,10) order by random(); produces sorted output. Should it? -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers ... 16 Nov 2009 01:27

Writeable CTE patch
I wrote: Attached is the latest version of this patch. Here's that same patch in context diff format. Sorry for the noise. Regards, Marko Tiikkaja ... 7 Dec 2009 17:22

named parameters in SQL functions
Andrew Dunstan wrote: At Tom's suggestion I am looking at allowing use of parameter names in SQL functions instead of requiring use of $1 etc. That raises the question of how we would disambiguate a parameter name from a column name. Essentially, ISTM, we could use some special marker such as @ (... 16 Nov 2009 07:56

add more frame types in window functions (ROWS)
Hi, I've started reviewing your patch. I've already found some things that need work: - missing _readWindowFrameDef function (all nodes that are output from parse analysis must have both _read and _out functions, otherwise views can't work) - the A_Const nodes should probably be transformed to Const ... 6 Dec 2009 22:46

patch - per-tablespace random_page_cost/seq_page_cost
On Sat, Nov 14, 2009 at 7:28 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: I ended up not reusing the reloptions.c code.  It looks like a lot of extra complexity for no obvious benefit, considering that there is no equivalent of AMs for tablespaces and therefore no need to support AM-specific options.  I d... 6 Jan 2010 13:09

DTrace compiler warnings
Hmm, const is also problem on solaris. dtrace generates probe.h file and eats const. It generates following noise on solaris build: "postgres.c", line 554: warning: argument #1 is incompatible with prototype: prototype: pointer to char : "../../../src/include/utils/probes.h", line 582 argument : pointer to co... 7 Dec 2009 19:36

[HACKERS] DTrace compiler warnings
I'm just seeing these kind of compiler warnings in current HEAD: pgstat.c: In function ‘pgstat_report_activity’: pgstat.c:2276: warning: passing argument 1 of ‘__dtrace_probe$postgresql$statement__status$v1$63686172202a’ discards qualifiers from pointer target type There are more of them (e.g. postgr... 14 Nov 2009 08:56

Aggregate ORDER BY patch
Andrew Gierth wrote: Herewith a patch to implement agg(foo ORDER BY bar) with or without DISTINCT, etc. What does that mean? Aggregate functions are supposed to be commutative, right? No artificial restrictions are imposed on what syntactical combinations are allowed. However, ORDER BY is not allowed ... 20 Dec 2009 10:19