Re: How to keep format of views source code as entered? - Mailing list pgsql-general

From Paul Förster
Subject Re: How to keep format of views source code as entered?
Date
Msg-id D5C683A7-00A3-4D6A-8F04-CAD7E28B6012@gmail.com
Whole thread Raw
In response to Re: How to keep format of views source code as entered?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Hi Laurenz,

> On 14. Jan, 2021, at 04:59, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> If PostgreSQL were to store the original text, either that text would become
> wrong, or you would have to forbid renaming of anything that is referenced
> by a view.

this is why views, procedures, functions and packages can become invalid in Oracle, which I really hate because as a
DBA,it's almost impossible to quickly see (or in fact see at all) why this happens, or having to debug applications
thatyou don't know and/or can't fix anyway. Oracle's invalid object concept doesn't make sense. 

So, I'm not at all in favor of saving the original statement text.

Cheers,
Paul


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to keep format of views source code as entered?
Next
From: Lukasz Biegaj
Date:
Subject: Re: Logical replication gradually slowing down, then hanging.