Re: Re[2]: PG 14.5 -- Impossible to restore dump due to interaction/order of views, functions, and generated columns

2022-12-07 Thread Tom Lane
"Nunya Business" writes: > Thanks Tom. There are indeed circular references in the schema and the > whole thing sort of doesn't pass the smell test, but this is my first > look at it. The generated column on the table calls a function which > selects from a view that references the table.

Re[2]: PG 14.5 -- Impossible to restore dump due to interaction/order of views, functions, and generated columns

2022-12-07 Thread Nunya Business
"Nunya Business" writes: Within my schema there is a table that has a GENERATED ALWAYS column that calls a plpgsql function. The called function has a "row type" variable declared that references a view. While the schema itself functions properly day to day, and pg_dumpall works as