Re: [HACKERS] Re: [HACKERS] generated columns

2018-01-02 Thread Peter Eisentraut
On 12/31/17 12:54, Joe Conway wrote: > Anyway, I have seen requests for change data capture > (https://en.wikipedia.org/wiki/Change_data_capture) in Postgres which is > apparently available in our competition without requiring the use of > triggers. Perhaps that is yet a different feature, but I wa

Re: [HACKERS] Re: [HACKERS] generated columns

2017-12-31 Thread Joe Conway
On 12/31/2017 09:38 AM, Peter Eisentraut wrote: > On 12/30/17 16:04, Joe Conway wrote: >> + >> + The generation expression can refer to other columns in the table, but >> + not other generated columns. Any functions and operators used must be >> + immutable. References to other tables are not all

Re: [HACKERS] Re: [HACKERS] generated columns

2017-12-31 Thread Peter Eisentraut
On 12/30/17 16:04, Joe Conway wrote: > + > + The generation expression can refer to other columns in the table, but > + not other generated columns. Any functions and operators used must be > + immutable. References to other tables are not allowed. > + > > Question -- when the "stored" kind of g

Re: [HACKERS] Re: [HACKERS] generated columns

2017-12-30 Thread Joe Conway
On 12/27/2017 09:31 AM, Peter Eisentraut wrote: > On 9/12/17 15:35, Jaime Casanova wrote: >> On 10 September 2017 at 00:08, Jaime Casanova >> wrote: >>> >>> During my own tests, though, i found some problems: > > Here is an updated patch that should address the problems you have found. In the co