Luca Ferrari

Open Source advocate, human being

What happens when you add a column?

Adding a column with a default value requires a full table rewrite, and therefore it is often suggested to avoid the default value. However, it is possible to add the default value without having PostgreSQL perform the full table rewrite.

written sometime in April 2018

Tags: postgresql , planet-postgresql-org

PostgreSQL 10 short course in Modena

The local Linux Users’ Group ConoscereLinux is delivering a six-part course on PostgreSQL 10. Guess who’s lecturing…

written sometime in April 2018

Tags: postgresql , planet-postgresql-org , itpug

PostgreSQL 10 and Python 3 (on FreeBSD)

Today a friend of mine asked me for a trouble between PostgreSQL 10 and Python. Since I’m not a pythonist, my quick answer was that PostgreSQL 10 does support Python 3. But it turned out it was not so simple (at least, not so simple as to get Perl 5 working!).

written sometime in April 2018

Tags: postgresql , planet-postgresql-org , python

psql verbose quit

A few days ago a new commit hit the psql code repository: there will be support for explicitly exiting from the command prompt.

written sometime in February 2018

Tags: postgresql

Perlbrew: added the verbose option

Another little contribution to the great perlbrew application.

written sometime in February 2018

Tags: perl5 , perlbrew

Newer articles Older articles
There are 1058 total articles on this blog, you are viewing page 13 of 212.