Re: schema agnostic functions in language sql

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: schema agnostic functions in language sql
Date: 2020-05-16 15:12:58
Message-ID: CAKFQuwY2FBJSrNkb2tvS2F2Pg_b5=_0PXDD9AN-mav9CiaH1jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, May 16, 2020 at 5:15 AM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

> check_function_body=off may be what I want during the site install as the
> definitions should be correct in all aspects.
>

You should probably just have one "test" schema and compile your functions
with the non-client test schema in the search_path.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Magnum 2020-05-16 15:18:57 Removing Last field from CSV string
Previous Message Suhail Bamzena 2020-05-16 14:52:31 Re: Inherited an 18TB DB & need to backup