PgSql

get_relation_stats_hook()
Currently we have a plugin capability for get_relation_info_hook(), but no corresponding capability for statistics info. So, all calls to SearchSysCache would be replaced with a call to get_relation_info_hook(), if present. Any objections, thoughts? -- Simon Riggs www.2ndQuadrant.com PostgreSQ... 26 Jun 2008 15:39

plpgsql: Is ELSE IF supported or not?
Docs seems to say it is, but following function fails to compile: create function err_else() returns void as $$ begin if 1 = 1 then else if 1 = 2 then end if; end; $$ language plpgsql; ERROR: syntax error at or near ";" LINE 6: end; Version 8.3.3. -- marko -- Sent via pgsql-hacker... 26 Jun 2008 13:35

Planner creating ineffective plans on LEFT OUTERjoins
On Wed, 2008-06-25 at 23:34 -0400, Robert Haas wrote: I can predict that Tom will say that the planning time it would take to avoid this problem isn't justified by the number of queries that it would improve. That's possible, but it's unfortunate that there's no way to fiddle with the knobs and get... 26 Jun 2008 15:39

Yuan, Welcome! To get you going till someone of quite higher blessing then me can answer, some helpfull links: http://www.postgresql.org/developer/ on this page specially the following sections: http://wiki.postgresql.org/wiki/Developer_FAQ if you are looking for a concrete job to do http://www.po... 27 Jun 2008 00:53

Proposal of SE-PostgreSQL patches
Added to TODO: * Improve server security options http://archives.postgresql.org/pgsql-hackers/2008-04/msg01875.php http://archives.postgresql.org/pgsql-hackers/2008-05/msg00000.php --------------------------------------------------------------------------- KaiGai Kohei wrote: I updated the serie... 26 Jun 2008 12:33

Proposed Patch - LDAPS support for servers onport 636 w/o TLS
Added to TODO: * Improve LDAP authentication configuration options http://archives.postgresql.org/pgsql-hackers/2008-04/msg01745.php --------------------------------------------------------------------------- steve layland wrote: -- Start of PGP signed section. Thank you all for your comments. I ... 25 Jun 2008 23:14

TODO Item: Allow pg_hba.conf to specify host names along with IP addresses
Thanks for all yours suggestions, use cases and opinion about this thread, I saw that there are more things to consider than I was thinking and this make me consider that it is a hard work to do for now. -- []s Dickson S. Guedes ------------------------------------- Projeto Colmeia - Curitiba - PR +55 (41) ... 26 Jun 2008 17:43

GIT repo broken
Hi, I noticed the other day that the branches in the GIT postgresql.git repository do not contain any patch after it was released. For example, in http://git.postgresql.org/?p=postgresql.git;a=shortlog;h=REL8_3_STABLE the last commit is on 2008-02-12. For example this commit is not there: http://anoncvs.p... 25 Jun 2008 16:02

Latest on CITEXT 2.0
Howdy, I just wanted to report the latest on my pet project: implementing a new case-insensitive text type, "citext", to be locale-aware and to build and run on PostgreSQL 8.3. I'm not much of a C programmer (this is only the second time I've written *anything* in C), so I also have a few questions about... 1 Jul 2008 12:19

Creating a VIEW with a POINT column
I have a VIEW that consists of two tables, of which contain a POINT column. When trying to select from the view I get an error... ERROR: could not identify an ordering operator for type point HINT: Use an explicit ordering operator or modify the query. Any suggestions??? -Nick ... 26 Jun 2008 08:25