Re: [HACKERS] generated columns - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] generated columns
Date
Msg-id CA+Tgmobe2CiJ3xHuaGgvv43nZVyR3oyQ6tx_r3nSYsdZMirzMQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] generated columns  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Tue, Sep 12, 2017 at 10:04 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> I think an option to decide whether the default is STORED or VIRTUAL
> would be useful.

That seems like it could be a bit of a foot-gun.  For example, an
extension author who uses generated columns will have to be careful to
always specify one or the other, because they don't know what the
default will be on the system where it's deployed.  Similarly for an
author of a portable application.  I think it'll create fewer
headaches if we just pick a default and stick with it.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [HACKERS] Parallel Hash take II
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] Is it time to kill support for very old servers?