odd (maybe) procedure cacheing behaviour

2023-03-15 Thread Tim . Colles
See noddy example below (v14.6). Presumably this is a result of procedure cacheing as per docs. The EXECUTE plan is being prepared fresh (again as expected from the docs and per the error message) but is the input argument type of NEW.x for the format() call still cached? Is altering a table col

Re: How to keep format of views source code as entered?

2021-01-08 Thread Tim . Colles
On Fri, 8 Jan 2021, Karsten Hilbert wrote: Am Fri, Jan 08, 2021 at 08:38:29AM + schrieb Markhof, Ingolf: I am really surprised that PostgreSQL is unable to keep the source text of a view. Honestly, for me the looks like an implementation gap. Consider software development. You are writing