Postgres Pro
Downloads
Home   >   mailing lists

Re: plpgsql and intarray extension; int[] - int[] operator does not exist ? - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql and intarray extension; int[] - int[] operator does not exist ?
Date
Msg-id 15705.1542650179@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql and intarray extension; int[] - int[] operator does notexist ?  ("Day, David" <david.day@redcom.com>)
Responses RE: plpgsql and intarray extension; int[] - int[] operator does notexist ?
Re: plpgsql and intarray extension; int[] - int[] operator does notexist ?
List pgsql-general
Tree view 
"Day, David" <david.day@redcom.com> writes:
> Any suggestions as to why the int[] operations are not understood in the trigger context.?

The search_path in the trigger probably doesn't include public.
You could add a "SET search_path = whatever" clause to the trigger
function definition to ensure it runs with a predictable path.

            regards, tom lane

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations
Next
From: "Day, David"
Date:
Subject: RE: plpgsql and intarray extension; int[] - int[] operator does notexist ?