Conferences
Back from CHAR(10)
It surely does not feel like a full month and some more went by since we were enjoying PGCon 2010, but in fact it was already the time for CHAR(10). The venue was most …
Posts
PostgreSQL
Back from PgCon2010
This year’s edition has been the best pgcon ever for me. Granted, it’s only my third time, but still :) As Josh said the “Hall Track” in …
Projects
Import fixed width data with pgloader
So, following previous blog entries about importing fixed width data, from Postgres Online Journal and David (perl) Fetter, I couldn’t resist following the meme and …
Projects
pgloader activity report
Yes. This pgloader project is still maintained and somewhat active. Development happens when I receive a complaint, either about a bug in existing code or a feature in …
PostgreSQL
Finding orphaned sequences
This time we’re having a database where sequences were used, but not systematically as a default value of a given column. It’s mainly an historic bad idea, …
Software Programming
Emacs Muse hacking
Now you know what piece of software is used to publish this blog. I really like it, the major mode makes it a great experience to be using this tool, and the fact that …
PostgreSQL
Getting out of SQL_ASCII, part 2
So, if you followed the previous blog entry, now you have a new database containing all the static tables encoded in UTF-8 rather than SQL_ASCII. Because if it was not …
PostgreSQL
Getting out of SQL_ASCII, part 1
It happens that you have to manage databases designed by your predecessor, and it even happens that the team used to not have a DBA. Those histerical raisins can lead to …
PostgreSQL
Resetting sequences. All of them, please!
So, after restoring a production dump with intermediate filtering, none of our sequences were set to the right value. I could have tried to review the process of …
Projects
pg_staging's bird view
One of the most important feedback I got about the presentation of pgstaging were the lack of pictures, something like a bird-view of how you operate it. Well, thanks to …
Conferences
PGday.eu feedback
At pgday there was this form you could fill to give speakers some feedback about their talks. And that’s a really nice way as a speaker to know what to improve. And …
Projects
prefix 1.1.0
So I had two bug reports about prefix in less than a week. It means several things, one of them is that my code is getting used in the wild, which is nice. The other side …