Skip to content

Category: Technology

Unique constraints and indexes in PostgreSQL

This afternoon, I had to add a unique index for some table in the Sicirec PostgreSQL database. I had already assumed that I needed to use CREATE UNIQUE INDEX to create my new unique index until I noticed, thanks to pgAdmin's clear GUI, that some tables clearly had unique constraints and unique indexes while one table lacked a unique constraint and only had an unique index defined. Read More »

Rowan Rodrik van der Molen

About the author. Read More »

Wiebe Hedde Cazemier

If you're into Open Source software, 3D modeling or Do It Yourself audio, you may already know Wiebe under his on-line alias, Halfgaar. Personally, I've known him since I was 10 and he was 9. These days he's still a very good friend, and even a colleague. Read More »