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 …
tag
Plpgsql
6 posts
Projects
Introducing Extensions
After reading Simon’s blog post, I can’t help but try to give some details about what it is exactly that I’m working on. As he said, there are several …
PostgreSQL
Editing constants in constraints
We’re using constants in some constraints here, for example in cases where several servers are replicating to the same federating one: each origin server has his …
debian
Emacs and PostgreSQL
Those are my two all times favorite Open Source Software. Or Free Software in the GNU sense of the world, as both the BSD and the GPL are labeled free there. Even if I …
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
Importing XML content from file
The problem was raised this week on IRC and this time again I felt it would be a good occasion for a blog entry: how to load an XML file content into a single field? The …