PgSql

PATCH: CITEXT 2.0 v2
David E. Wheeler napsal(a): On Jun 27, 2008, at 18:22, David E. Wheeler wrote: Please find attached a patch adding a locale-aware, case-insensitive text type, called citext, as a contrib module. Here is a new version of the patch, with the following changes: * Fixed formatting to be more l... 9 Jul 2008 13:42

Schema-qualified statements in pg_dump output
There's a behavior in pg_dump that annoyed me a little bit, the last few times i had to deal with it: Consider you have to dump a specific namespace only, you are going to use pg_dump -n <your_schema> [-t <tables>]. I found it a common use case to restore this dump into a different schema by simply changin... 22 Jul 2008 16:48

Missing descriptions for aggregates
I'm about to add/cleanup some missing descriptions for aggregates and functions (such as corr(), enum_first()....) and discovered that stddev(), min() and others doesn't have a pg_description entry, too. Is there a reason for that? Maybe keep off redundant information from pg_description? -- Thanks ... 7 Jul 2008 22:47

pg_ctl -w with postgresql.conf in non-default path
Hello guys, This is my first post to this list.. I'm using PostgreSQL8.3.3 and I moved postgresql.conf to the outside of DATA direcotory, and invoked postgres via pg_ctl as following. pg_ctl -w -D /data -o '--config-file=/home/hirano/postgresql.conf' start This seems to work well, but when I changed the p... 7 Jul 2008 12:29

WIP: executor_hook for pg_stat_statements
Simon Riggs <simon(a)2ndquadrant.com> wrote: The attached patch (executor_hook.patch) modifies HEAD as follows. - Add "tag" field (uint32) into PlannedStmt. - Add executor_hook to replace ExecutePlan(). - Move ExecutePlan() to a global function. The executor_hook.patch is fairly trivi... 18 Jul 2008 17:32

Sorting writes during checkpoint
(Go back to -hackers) Simon Riggs <simon(a)2ndquadrant.com> wrote: No action on this seen since last commitfest, but I think we should do something with it, rather than just ignore it. I will have a plan to test it on RAID-5 disks, where sequential writing are much better than random writing. I'll send the... 16 Jul 2008 02:44

Priority of timezone names vs abbreviations in AT TIME ZONE
I've been thinking about the complaint here: http://archives.postgresql.org/pgsql-general/2008-07/msg00201.php and I think that the real issue boils down to the fact that timestamp input checks a name against the timezone abbrevs list first, and the zic database second; whereas the various forms of AT TIME ZONE do... 6 Jul 2008 18:06

Solaris ident authentication using unix domainsockets
Robert Treat wrote: On Thursday 03 July 2008 14:01:22 Tom Lane wrote: Garick Hamlin <ghamlin(a)isc.upenn.edu> writes: I have a patch that I have been using to support postgresql's notion of ident authentication when using unix domain sockets on Solaris. This patch basically just... 5 Jul 2008 19:40

time_stamp type
What's the deal with this type? Is it used internally? It's the only type that seems to have anything meaningfull in typdefaultbin and typdefault columns in pg_type. -- Sincerely, Stephen R. van den Berg. WARNING: Do not look into laser with remaining eye -- Sent via pgsql-hackers mailing list... 6 Jul 2008 01:46

introduction of WIP window function patch
Hi, As I proposed a month before, I am working on window function. Although this work is at quite early step, I would like to introduce it since a part of it have been finished. If you can afford and are interested in it, please review the document and patch, or compile the applied source to execute an attached ... 17 Jul 2008 05:29