PgSql

[HACKERS] Error when building postgresql with contrib functions
Hi I am trying to build postgresql with contrib functions from source code checked out from cvs version 8.3.8 but getting error: ================== conifer=# SELECT * FROM xpath_table('id', 't', 'xpath_test', '/doc/int', 'true') as t(id int4); ERROR: function xpath_table(unknown, unknown, unknown, unknown, u... 15 Feb 2010 18:54

[HACKERS] getting version 7.2.8
Dear Folks, I need to get a copy of PostGres source for version 7.2.8. In particular I need to build PostGres for now unsupported BeOS. I don't see V 7.2.8 on the download mirror. Can someone please provide info on accessing an older version? Many thanks, Andrew ... 15 Feb 2010 15:29

[HACKERS] RADIUS secret in file
Attached is the "last step" of the RADIUS authenticaiton as I promised Stephen - which allows the reading of the RAIDUS secret from a file instead of hardcoded in pg_hba.conf. One reason being you don't want the secret in your config file that may be in a shared repository or such. IIRC Stephen had some other reaso... 15 Feb 2010 15:29

Regression failure on pika caused by CLUSTER rewrite
Le 15 févr. 2010 à 12:52, Greg Stark <stark(a)mit.edu> a écrit : In looking through the build farm wreckage caused by fsyncing directories I noticed this interesting failure on pika: ================== pgsql.13659/src/test/regress/regression.diffs =================== *** /home/pgbuildfarm/workdir/H... 15 Feb 2010 14:20

[HACKERS] plperl message style on newly added messages
Hi, I notice that the new plperl error messages are somewhat out of line of our usual style: ereport(ERROR, (errcode(ERRCODE_INTERNAL_ERROR), errmsg("while executing utf8fix"), errdetail("%s", strip_trailing_ws(SvPV_nolen(ERRSV)))... 15 Feb 2010 13:12

LISTEN/NOTIFY and notification timing guarantees
Joachim Wieland <joe(a)mcknight.de> writes: One question regarding #2: Is a client application able to tell whether or not it has received all notifications from one batch? i.e. does PQnotifies() return NULL only when the backend has sent over the complete batch of notifications or could it also return NULL w... 17 Feb 2010 04:29

[HACKERS] ToDo: preload for fulltext dictionary
Hello, Czech users reports a slow first fulltext queries. It is based on using ispell dictionary. The dictionary data could be shared or minimally dictionary could be preloaded like some PL language. What do you think about this? Regards Pavel Stehule -- Sent via pgsql-hackers mailing list (pgsql-ha... 15 Feb 2010 13:12

Documentation build issues on Debian/Ubuntu
Greg Smith wrote: I can't seem to build the PDF version of the documentation on any of my Ubuntu 9.04 systems, and wonder if there's anything that can/should should get done about it. Yeah, I'm seeing the same problem here. The strange thing is that 8.4 docs seem to build just fine. -- Alvaro Herrera... 15 Feb 2010 13:12

RADIUS secret in file
* Magnus Hagander (magnus(a)hagander.net) wrote: IIRC Stephen had some other reason, but I'll leave it to him to fill that in :-) I was really looking for multi-server support as well, and support for a config-file format that's commonly used for RADIUS. I'll take a whack at doing that this evening. Thank... 15 Feb 2010 15:29

[COMMITTERS] pgsql: Add psql tab completion for DO blocks.
Tom Lane <tgl(a)sss.pgh.pa.us> wrote: itagaki(a)postgresql.org (Takahiro Itagaki) writes: This syntax synopsis is completely nuts: DO { [ LANGUAGE lang_name ] | code } ... I think that it would be logically correct without the square brackets, Oops, that's correct. but as a matter of clarity I r... 15 Feb 2010 05:25