Re: Inconsistent compilation error

[Adrian Klaver]

On 04/18/2018 06:02 PM, r...@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?


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.kla...@aklaver.com