Andrew Dunstan's PostgreSQL and Technical blog

This time for sure (h/t Bullwinkle) Yesterday I finally turned off my Windows XP instance for good. It's been running for quite a long...

 The output from running a buildfarm step is the output from running a command such as make check followed by any relevant log files that th...

 This is to announce release 14 of the PostgreSQL Buildfarm client. Significant changes: don't run TestUpgrade if TAP tests are present...

  I have just pushed Release 13.1 of the PostgreSQL BuildFarm client. This update to Release 13 fixes errors that occur from the new defaul...

I have pushed Release 13 of the PostgreSQL BuildFarm client. Change highlights: add tests for a few cases that were previously missin...

Recent discussion set me thinking about what would be involved in setting up standalone TAP tests for Postgres, to do, say, more code covera...

In keeping with modern git practice, I have renamed the default branch on both the client-code and server-code repositories to main . If y...

It's possible to use EXPLAIN output in plpgsql. In the default text format, the result comes back as a set of text values, so you can pr...

With one very small exception, there is nothing in the buildfarm server that requires the client to be running perl, even though both the se...

I just discovered after a great deal of puzzlement and far too much time that if you run multiple instances of Postgres on a machine, and yo...

Common Table Expressions are a wonderful thing. Not only are they indespensible for creating recursive queries, but they can be a powerful t...

I just committed a patch to allow building with Visual Studio 2015. Due to a change in the way we need to detect locales with this compiler,...