Posts

PostgreSQL

Dynamic Triggers in PLpgSQL

You certainly know that implementing dynamic triggers in PLpgSQL is impossible. But I had a very bad night, being up from as soon as 3:30 am today, so that when a …

PostgreSQL

pg_basebackup

Hannu just gave me a good idea in this email on -hackers, proposing that pg_basebackup should get the xlog files again and again in a loop for the whole duration of the …

PostgreSQL

Date puzzle for starters

The PostgreSQL IRC channel is a good place to be, for all the very good help you can get there, because people are always wanting to remain helpful, because of the …

Projects

el-get reaches 1.0

It’s been a week since the last commits in the el-get repository, and those were all about fixing and adding recipes, and about notifications. Nothing like core …

Software Programming

Postfix sender_dependent_relayhost_maps

The previous article about M-x mailq has raised several mails asking me details about the Postfix setup I’m talking about. The problem we’re trying to solve …

Software Programming

Scratch that itch: M-x mailq

Nowadays, most people would think that email is something simple, you just setup your preferred client (that’s called a MUA) with some information such as the smtp …

PostgreSQL

Window Functions example remix

The drawback of hosting a static only website is, obviously, the lack of comments. What happens actually, though, is that I receive very few comments by direct mail. As I …