Daniel Westermann

Improve your development experience in PostgreSQL’s PL/pgSQL by using plpgsql_check

In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while developing(…)

Some tips when developing in PostgreSQL’s PL/pgSQL

When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures, nor(…)

PostgreSQL 16: More flexibility for vacuum and analyze

Update 14-Dec-2022: Please see this post, the content here is not anymore up to date. While PostgreSQL 15.1 was released some weeks ago PostgreSQL 16 is already under active development. Two(…)

An introduction to OMrun – 2 – Working with parameters

In the last post we compared the list of databases in the same PostgreSQL cluster using OMrun. The setup for this was pretty simple: We’ve defined the environment using the PostgreSQL Data Adapter and created the(…)

An introduction to OMrun – 1 – A simple data comparison with the PostgreSQL Adapter

With the integration of OMIS into dbi services we also got a new product: OMrun. OMrun is all about data, especially comparing, validating and anonymizing data from various sources against various targets.

PostgreSQL: Dropping a table automatically if another table is dropped

Imagine the following use case: You have a table t1, and based on it’s contents you create another table t2. What you want to achieve is: If table t1 gets dropped, you want to have table t2 to be dropped(…)

2022.pgconf.eu, what a blast

2022.pgconf.eu is currently happening in Berlin. We have a record number of 600 attendees, this makes it the largest ever PostgreSQL Conference Europe and we’re hitting the hard limits of the venue.

Meson vs. make: PostgreSQL build and test times

In the last post we’ve looked into how you can build PostgreSQL with Meson instead of the traditional way using configure/make. The reason for this was a thread(…)

Building PostgreSQL with Meson

Last year, around this time, there started a thread on hackers which was about building PostgreSQL with meson. I didn’t know anything about Meson at this time, and don’t know much more(…)

PostgreSQL from packages on NetBSD

The last flavor of BSD we’ll look at is NetBSD. We already had FreeBSD (here and here) and OpenBSD (here and(…)