Luca Ferrari
Open Source advocate, human being
PostgreSQL negative PID
PostgreSQL uses a simple trick to recognize if the server has started in single-user mode.
An example of PostgreSQL rules: updating pg_settings
Rules are a powerful mechanism by which PostgreSQL allows a statement to be transformed into another. And PostgreSQL itself does use rules in order to make your life easier.
Is it me writing in Python?
I never wrote a row of Python, until…
Emacs Org-mode and the not exported caption problem
Org-mode is an amazing tool I use every day for pretty much a lot of stuff. In these day I’ve written technical documents in org, but due to a fault of mine, every code snippet was without the appropriate caption. It took me a while to find out what I was missing…
pgxnclient and beta version
pgxnclient is a wonderful cpan like tool for the PGXN extension network. Unlickily, the client cannot handle PostgreSQL beta version, so I submitted a really small patch to fix the issue.
PostgreSQL 11 and PL/Java: it can work!
PL/Java is a wonderful piece of code that allows the definition of functions in Java directly within PostgreSQL. Unluckily, PostgreSQL 11 introduced a few changes that made PL/Java not compiling. But keep calm, experts are already working on this!
PostgreSQL Extended Statistics
PostgreSQL 10 allows users to define extended statistics to help the planner understand data dependencies.
Sqitch and Sqitchers
Sqitch has nothing particular to do with PostgreSQL, except it does support our beloved database!
PostgreSQL: cannot alter type of a column used by a view or rule
How to cascade changes to a view over a table?
PostgreSQL BSD Magazine course ebook
I’ve completed another short course on PostgreSQL, this time online with written material.