Adrian Klaver wrote:
> On 04/18/2018 06:02 PM, raf@raf.org wrote:
> > Hi,
> >
> > postgresql-9.5.12 on debian-9
> >
> > I have a stored function with code that looks like:
> >
> > create or replace function tla_audit_delete_thing()
> > returns boolean stable language plpgsql as $$
> > declare
> > r record;
> > status boolean := 1;
> > begin
> > for r in select _.* from blah_history _ where _.original_id not in (select id from blah)
> > loop
> > raise notice '% %', 'blah_history.original_id', r;
> > status := 0;
> > end loop;
> > [...]
> > end
> > $$
> > security definer
> > set search_path = public, pg_temp;
> > revoke all on function tla_audit_delete_thing() from public;
> > grant execute on function tla_audit_delete_thing() to staff;
>
> So if you cut and paste the above directly into the database via psql on the
> Debian host do you see the same issue?
No. Cutting and pasting the text into psql works fine.
> > And I have a program that loads stored functions from disk
> > when they are different to what's in the database and I have
> > just loaded a very old database backup, brought the schema up
> > to date, and tried to bring the stored functions up to date.
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
