pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: raf <raf@raf.org>
To: pgsql-general@lists.postgresql.org
Subject: Re: Stored procedure code no longer stored in v14 and v15, changed behaviour
Date: Sat, 3 Dec 2022 09:18:52 +1100
Message-ID: <Y4p5zFSbWey0pm8d@raf.org> (raw)
In-Reply-To: <1937424.1669996938@sss.pgh.pa.us>
References: <23DE96C56DFC404096553A22DDC5093B@MARTIJNWS>
	<CAKFQuwbYCk0oA3VT+ngEebBTBjdtGsVLEFOdPX2qqQJobA7rtg@mail.gmail.com>
	<1579912.1669908194@sss.pgh.pa.us>
	<CAFCRh--K2tahGetbJ_mtjiwvfFb9fF6SzjGnvbyoMKPr92FiTQ@mail.gmail.com>
	<Y4lFsaF3xz24K0mr@raf.org>
	<CAJvus-MKW1tFhnotbQXbvCdXbfgH6WpvmExsMrYi1Yfov85KOA@mail.gmail.com>
	<Y4oB5RLrbTFLGWsW@raf.org>
	<CAJvus-O6qvF_3jNHZdfX5f-5s3FLSHhUHVyPYtgCzftYH+CYXg@mail.gmail.com>
	<1937424.1669996938@sss.pgh.pa.us>

On Fri, Dec 02, 2022 at 11:02:18AM -0500, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Also, we've *never* had storage of the original text for views.
> I'm a little mystified by people claiming they use original
> text for vetting functions when they clearly have no equivalent
> ability for views ... or are your applications completely
> view-free?

In my case, yes, all access is via procedures.
No views or triggers. So it was OK.

cheers,
raf






view thread (37+ messages)  latest in thread

Message-ID: <Y4p5zFSbWey0pm8d@raf.org>
Permalink:  ../Y4p5zFSbWey0pm8d@raf.org/
Also on:    postgresql.org/message-id/Y4p5zFSbWey0pm8d@raf.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: raf@raf.org
  Subject: Re: Stored procedure code no longer stored in v14 and v15, changed behaviour
  In-Reply-To: <Y4p5zFSbWey0pm8d@raf.org>
  References: <23DE96C56DFC404096553A22DDC5093B@MARTIJNWS> <CAKFQuwbYCk0oA3VT+ngEebBTBjdtGsVLEFOdPX2qqQJobA7rtg@mail.gmail.com> <1579912.1669908194@sss.pgh.pa.us> <CAFCRh--K2tahGetbJ_mtjiwvfFb9fF6SzjGnvbyoMKPr92FiTQ@mail.gmail.com> <Y4lFsaF3xz24K0mr@raf.org> <CAJvus-MKW1tFhnotbQXbvCdXbfgH6WpvmExsMrYi1Yfov85KOA@mail.gmail.com> <Y4oB5RLrbTFLGWsW@raf.org> <CAJvus-O6qvF_3jNHZdfX5f-5s3FLSHhUHVyPYtgCzftYH+CYXg@mail.gmail.com> <1937424.1669996938@sss.pgh.pa.us> <Y4p5zFSbWey0pm8d@raf.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox