The Art of PostgreSQL

el-get 2.2

Thursday 26 2011 1 mins read Emacs, el-get

We’ve spotted a little too late for our own taste a discrepancy in the source tree: a work in progress patch landed in git just before to release el-get stable. So we cleaned the tree (thanks again Julien), branched a stable maintenance tree, and released 2.2 from there. You’re back to enjoying el-get :)

I wrote a book!

Preparing for PGCON

Thursday 12 2011 2 mins read PostgreSQL, Extensions

pgcon Extensions

It’s this time of the year again, the main international PostgreSQL Conference is next week in Ottawa, Canada. If previous years are any indication, this will be great event where to meet with a lot of the members of your community. The core team will be there, developers will be there, and we will meet with users and their challenging use cases. This is a very good time to review both what you did in the project those last 12 months, and what you plan to do next year.

Mailq modeline display

Thursday 05 2011 2 mins read Software Programming, Emacs Lisp

Emacs el-get modeline cssh mailq postfix

If you’ve not been following along, you might have missed it: it appears to me that even today, in 2011, mail systems work much better when setup the old way. Meaning with a local MTA for outgoing mail. With some niceties, such as sender dependent relayhost maps. That’s why I needed M-x mailq to display the mail queue and have some easy shortcuts in order to operate it (mainly f runs the command mailq-mode-flush, but per site and per id delivery are useful too).

Tables and Views dependencies

Wednesday 04 2011 3 mins read PostgreSQL, YeSQL

catalogs

Let’s say you need to ALTER TABLE foo ALTER COLUMN bar TYPE bigint;, and PostgreSQL is helpfully telling you that no you can’t because such and such views depend on the column. The basic way to deal with that is to copy paste from the error message the names of the views involved, then prepare a script wherein you first DROP VIEW then ALTER TABLE and finally CREATE VIEW again, all in the same transaction.

Extension module_pathname and .sql.in

Monday 02 2011 2 mins read Projects, prefix

debian Extensions release prefix 9.1

While currently too busy at work to deliver much Open Source contributions, let’s debunk an old habit of PostgreSQL extension authors. It’s all down to copy pasting from contrib, and there’s no reason to continue doing $libdir this way ever since 7.4 days. Let’s take an example here, with the prefix extension. This one too will need some love, but is still behind on my spare time todo list, sorry about that.

Emacs and PostgreSQL, PL line numbering

Saturday 23 Apr 2011 1 mins read Emacs, el-get

Emacs el-get pgsql-linum-format

A while ago I’ve been fixing and publishing pgsql-linum-format separately. That allows to number PL/whatever code lines when editing from Emacs, and it’s something very useful to turn on when debugging. The carrets on the fringe in the emacs window are the result of (setq-default indicate-buffer-boundaries 'left) and here it’s just overloading the image somehow. But the idea is to just M-x linum-mode when you need it, at least that’s my usage of it.