Category Archives: Postgres

Thoughts on the care and feeding of Postgres

Postgres and hstore

I recently started working with the hstore contrib module in Postgresql.  My impetus was  the desire to create a generic way of redirecting deletes on key tables to archive tables.  I do that now using a rule based mechanism. The … Continue reading

Posted in Postgres | 8 Comments

Making things easier

Have not trolled the source enough to know who specifically to thank, so a general thank you to whoever is responsible for \e(f) in psql and the command DO. I have been working on a fairly complex plpythonu function in … Continue reading

Posted in Postgres | 1 Comment

PostgreSQL 9.1, first beta around the corner

Joshua Berkus recently gave a heads up on the Advocacy list of the forthcoming release of the first beta for PostgreSQL 9.1, tentatively scheduled for May 3.  I have been following the development fairly closely, though given the number of … Continue reading

Posted in Postgres | Comments Off on PostgreSQL 9.1, first beta around the corner

Troubleshooting

Some thoughts on the art and science of troubleshooting, or how not to resort to the bigger hammer. What I offer up is based on my experience trying to solve problems across an array of disciplines, from truck repair to … Continue reading

Posted in Life lessons, Postgres | Comments Off on Troubleshooting

SQL inside Jedit

I use Jedit as my primary text editing tool. I recently ran across a plugin (SQL) to the editor that allows for running SQL from within an editor  buffer. What follows is an explanation of how to set it up … Continue reading

Posted in Postgres | Comments Off on SQL inside Jedit

PostgreSQL Roles

Today I got involved in a discussion on the General mailing list about using ROLE in Postgres.  I realized this is a topic that can get confusing in a hurry and I thought I might try to clear things up, … Continue reading

Posted in Postgres | 1 Comment

First Postgres post

This is more of a test post than anything. A way of checking that I have my feed to Planet PostgreSQL set up right. The point being to have only Postgres related posts come through, not my thoughts on cat … Continue reading

Posted in Postgres | Comments Off on First Postgres post