PostgreSQL Weekly News - November 13 2005
== PostgreSQL Weekly News - November 13 2005 ==
PostgreSQL 8.1 released :) Get the details here.
http://www.postgresql.org/docs/whatsnew
PostgreSQL 8.1.0 is now in the OpenBSD ports tree
Teodor Sigaev has been making lots of improvements to tsearch2, a
full-text search engine.
There have been lively discussions on -hackers of MERGE and
multi-table indexes. Let's keep it lively!
The folks at SRA sent some marketing material to a list of emails
they'd collected. Although they quickly apologized for sending it to
the wrong list, they have yet to destroy that list and commit not to
collect another one.
== PostgreSQL Product News ==
Wikipgedia 0.0.2 released.
http://pgfoundry.org/projects/wikipedia/
PL/sh 1.2 released.
http://pgfoundry.org/projects/plsh/
Greenplum has released Bizgres MPP Beta.
http://www.greenplum.com/mpp-beta/
pgPool 2.6.5 released.
http://pgfoundry.org/projects/pgpool/
PostgreSQL RPM Building Project has built 8.1.0 RPMs for many platforms.
http://archives.postgresql.org/pgsql-announce/2005-11/msg00017.php
PostgreSQL RPM Building Project has released a document about how to
install PostgreSQL RPMs on Red Hat / Fedora Core machines.
http://pgfoundry.org/docman/?group_id=1000048
Slony-I 1.1 has been changed to work with PostgreSQL 8.1. There are
no plans to back-patch Slony-I 1.0, so please take this opportunity to
upgrade.
psqlODBC 08.01.0100 is out.
http://www.postgresql.org/about/news.418
pgAdmin 1.4.0 released
http://www.postgresql.org/ftp/pgadmin3/beta/
== PostgreSQL Local ==
PostgreSQL Turkish User Group Web Page is up
http://www.PostgreSQL.org.tr
== PostgreSQL in the News ==
Andrew Dunstan has published an article on using Perl with PostgreSQL
http://www.oreillynet.com/pub/a/databases/2005/11/10/using-perl-in-postgresql.html
Planet PostgreSQL: http://www.planetpostgresql.org/
General Bits, published on Mondays (PST/PDT):
http://www.varlena.com/GeneralBits/
PostgreSQL Weekly News is brought to you this week by David Fetter
and Devrim Gunduz
On Sun, Nov 13, 2005 at 11:15:09PM -0800, David Fetter wrote:
== PostgreSQL Weekly News - November 13 2005 ==
Slony-I 1.1 has been changed to work with PostgreSQL 8.1. There are
no plans to back-patch Slony-I 1.0, so please take this opportunity to
upgrade.
Folks,
I made a mistake about the Slony-I updates for PostgreSQL 8.1.
Although the CVS branches have these changes, the changes are not yet
production quality, and so those changes have not yet been released.
The Slony-I team hopes to release these changes on or about November
28.
I apologize for the inconvenience I have caused, and am working more
closely with the rest of the Slony-I team to coordinate announcements
with facts on the ground.
Sincerely,
David.
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
David Fetter writes in PostgreSQL Weekly News - November 13 2005:
Teodor Sigaev has been making lots of improvements to tsearch2, a
full-text search engine.
I can't find them. Am I blind? Can someone help?
Look at HEAD branch.
Kaare Rasmussen wrote:
David Fetter writes in PostgreSQL Weekly News - November 13 2005:
Teodor Sigaev has been making lots of improvements to tsearch2, a
full-text search engine.I can't find them. Am I blind? Can someone help?
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/
On Tuesday 15 November 2005 04:03, Teodor Sigaev wrote:
Look at HEAD branch.
Kaare Rasmussen wrote:
David Fetter writes in PostgreSQL Weekly News - November 13 2005:
Teodor Sigaev has been making lots of improvements to tsearch2, a
full-text search engine.I can't find them. Am I blind? Can someone help?
Hey Teodor,
one thing that has confused me lately is figuring out where the latest code
for tsearch2 is kept. A number of places on the web indicate you can get
updated releases on places like the tsearch2 home page
(http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/) but I haven't found
anything relevent there or in the wiki or on the delta-soft web page. Is the
current development going on in the postgresql cvs tree then?
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
On Wed, 16 Nov 2005, Robert Treat wrote:
On Tuesday 15 November 2005 04:03, Teodor Sigaev wrote:
Look at HEAD branch.
Kaare Rasmussen wrote:
David Fetter writes in PostgreSQL Weekly News - November 13 2005:
Teodor Sigaev has been making lots of improvements to tsearch2, a
full-text search engine.I can't find them. Am I blind? Can someone help?
Hey Teodor,
one thing that has confused me lately is figuring out where the latest code
for tsearch2 is kept. A number of places on the web indicate you can get
updated releases on places like the tsearch2 home page
(http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/) but I haven't found
anything relevent there or in the wiki or on the delta-soft web page. Is the
current development going on in the postgresql cvs tree then?
current development is in the postgresql cvs tree, but we keep backpatches
on our page. Currently, we're working on full UTF-8 support for 8.2 and
other improvements. This is rather difficult task, but is very important for
our users and we'll publish patch for 8.1 release on our page.
We have our TODO
http://www.sai.msu.su/~megera/oddmuse/index.cgi/todo
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83