Debugging PostgreSQL More Easily

PostgreSQL is the foundation for thousands and thousands of applications. The system has long proven its worth and is operating reliably. However, the question people often ask is: What is the best way to actually debug a database application? For a couple of years now, I have been using a simple method that greatly speeds up the debugging process of typical applications. Using inheritance to store data One of the core features of PostgreSQL, which has been around for decades already, is the idea of "inheritance". So what does that mean, exactly? Simply speaking, tables can inherit columns from each other. A child table will simply have all the columns of the parent table, plus its own additional ones. But what does this mean in real life, and what does it have to do with debugging? Let us take a closer look: CREATE TABLE t_global ( id serial, tstamp timestamptz DEFAULT now() ); CREATE TABLE t_product ( name text, price numeric ) INHERITS (t_global); INSERT INTO t_product (name, p ... Read full article.