On 04/18/2018 06:02 PM, raf@xxxxxxx 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?
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.
cheers,
raf
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
