Re: Not able to restore generated columns due to a function

  Thank you David for your suggestions. I will fix the function and try.  

On Tue, Jan 26, 2021 at 7:21 AM David G. Johnston <david.g.johnston@gmail.com> wrote:

On Tue, Jan 26, 2021 at 8:16 AM Santosh Udupi <email@hitha.net> wrote:

Hi,

I am trying to restore a database with a generated column. The generated column is created using the function below. This column doesn't get restored. Can you tell me what I am doing wrong in the function?

I am calling a function within a function. Could this be the issue? 

Didn't look too deeply but normally failures of this nature mean you didn't schema-qualify your function names, either in the code body or with a SET attached to the create function command.

To compound matters you are ignoring all errors by "exception when others".  You should avoid "exception" if possible, including by testing for valid data first instead of letting the called function fail.

Your functions also are not immutable due to being sensitive to timezone settings.

David J.