::Planet PostgreSQL::::Planet PostgreSQL:: - http://www.planetpostgresql.org/Leo Hsu and Regina Obe: How to determine if text phrase exists in a table column- August 31, 2008 Common Case Scenario: You have a very aggravated person who demands you purge their email from any table you have in your system. You have lots of tables that have email addresses. How do you find which tables have this person's email address. Below is a handy plpgsql function we wrote that does the following. Given a search criteria, field name pattern, table_name pattern, schema name pattern, data type pattern, and max length of field to check, it will search all fields in the database...http://www.postgresonline.com/journal/index.php?/archives/69-How-to-determine-if-text-phra... Gavin M. Roy: Starting Development on Golconde- August 31, 2008 I’ve started prototyping Golconde, which is designed to be a loosely coupled data distribution system for PostgreSQL. The concept is to implement a trigger based tool using python and Stomp to send InsertsUpdatesDeletes to ActiveMQ which, as a message broker, will allow for the queries to be sent to one or many target systems. The goal here is not to implement a replication system, as there are fine PostgreSQL based tools for replication. Golconde is a system that does not care about..http://www.gavinroy.com/2008/8/31/starting-development-on-golconde Bruce Momjian: Report from Brasilia- August 30, 2008 I just gave my final presentation at Brazil's first open source e-government conference, CONSEGI 2008 (news report). I have never seen so much enthusiasm for open source and Postgres as I have seen here in Brasilia. Of course, the open source people don't feel open source is being adopted fast enough, but I have felt that way about Postgres since 1996, so this is to be expected. ;-) Read More »http://momjian.us/main/blogs/pgblog.html#August_30_2008 Pavel Stehule: updatable cursor's test- August 29, 2008 HelloI had to update every row of table with an result of external function. It was possibility for testing of some patterns:postgres= create table testcursor(i integer primary key, v integer);NOTICE: CREATE TABLE PRIMARY KEY will create implicit index "testcursor_pkey" for table "testcursor"CREATE TABLEpostgres= insert into testcursor select i, 0 from generate_series(1,100000) g(i);INSERT 0 100000postgres= analyze testcursor;ANALYZE external function sample create or replace function...http://okbob.blogspot.com/2008/08/updatable-cursors-test.html Selena Deckelmann: Leaving US PostgreSQL Assoc. - whats next for me- August 29, 2008 image credit to bugbunnybambam A few weeks ago, I decided to resign from the United States PostgreSQL Association board. Shortly after, I left for a long vacation where I thought about what I wanted to do next - both professionally and in a volunteer capacity. Looking back, I started volunteering for PostgreSQL two years ago. I&8217;ve led PDXPUG, staffed many conference booths, given nearly a dozen talks and run conferences. Of the work I&8217;ve done, I&8217;ve been most surprised by the...http://www.chesnok.com/daily/2008/08/28/leaving-us-postgresql-assoc-whats-next-for-me/ Hubert Lubaczewski: Hunting idle in transactions- August 28, 2008 If you ever encountered &8220;idle in transaction&8221; connections, you most likely hate them. I know, I personally hate them. They interfere with most of &8220;cool toys&8221; like replication, vacuum, DDL queries. So, when I saw them on a database I was looking on, I decided to act. Easier to say, difficult to do. How to fix the ...http://www.depesz.com/index.php/2008/08/28/hunting-idle-in-transactions/ Devrim Gndz: Keep informed about the latest updates for your distro- August 28, 2008 If you are using my rpm repository, you may also use its rss feed to keep informed about the latest RPM updates.Just click your environment at RPM Chart, and subscribe to RSS feed (it is easy if you are using Firefox).Yes, we aim to make your lives easierhttp://people.planetpostgresql.org/devrim/index.php?/archives/120-Keep-informed-about-the-... Bruce Momjian: The Kitchen Sink Has Arrived- August 28, 2008 There has been much discussion within the Postgres community about having a kitchen sink distribution of Postgres that bundles the database server with the many plug-ins available for Postgres. We have had something similar for Windows since 2005 but not for other operating systems. Such distributions are helpful for new users and people wanting to experiment with Postgres and its external enhancements. Read More »http://momjian.us/main/blogs/pgblog.html#August_28_2008 Robert Hodges: Answering Monty's Challenge: Advanced Replication for MySQL- August 28, 2008 Today Continuent is publishing the Tungsten Replicator, which provides advanced open source masterslave replication for MySQL. Publishing code is the first step to creating a robust alternative to current MySQL replication and will be followed by similar support for Oracle, PostgreSQL, and many other databases.We started with masterslave replication on MySQL for a very simple reason: we know it well. And we know that while MySQL replication has many wonderful features like simple set-up, it.http://scale-out-blog.blogspot.com/2008/08/answering-montys-challenge-advanced.html Jignesh K. Shah: Openbravo ERP on PostgreSQLOpenSolaris 2008.05- August 27, 2008 Interested in setting up an ERP for your business which uses PostgreSQL Here is an entry on how to install Openbravo ERP using PostgreSQLOpenSolaris 2008.05 Read morehttp://people.planetpostgresql.org/jkshah/index.php?/archives/10-Openbravo-ERP-on-PostgreS... |