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

From Peter Eisentraut
Subject Re: [HACKERS] generated columns
Date
Msg-id 6c9cc29a-64eb-d033-0909-b93f3a2b8c63@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] generated columns  (Erikjan Rijkers <er@xs4all.nl>)
Responses Re: [HACKERS] generated columns
List pgsql-hackers
On 31/10/2018 08:58, Erikjan Rijkers wrote:
> I have also noticed that logical replication isn't possible on tables 
> with a generated column.  That's a shame but I suppsoe that is as 
> expected.

This is an issue we need to discuss.  How should this work?

The simplest solution would be to exclude generated columns from the
replication stream altogether.

Similar considerations also apply to foreign tables.  What is the
meaning of a stored generated column on a foreign table?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Evgeniy Efimkin
Date:
Subject: Re: Special role for subscriptions
Next
From: Pavel Raiskup
Date:
Subject: Re: plruby: rb_iterate symbol clash with libruby.so