Re: Plpgsql search_path issue going from 9.3 to 9.6

[Adrian Klaver]

On 11/13/18 6:27 AM, George Woodring wrote:

I think the issue is that the function is not putting the data into the tickets%ROWTYPE correctly.  When I do \d on public.tickets and iss-hackers.tickets, the columns are in a different order.

The error message is saying column2 is not a timestamp, which the public table is a timestamp for column2.  If I change my SELECT in the function from SELECT * to SELECT opendate  I can fix my issue easily.

Or change this:

 SELECT * INTO ticket FROM tickets WHERE ticketsid=tid;

to:

 SELECT * INTO ticket FROM public.tickets WHERE ticketsid=tid;

This will match the ROWTYPE:

ticket public.tickets%ROWTYPE;

George
iGLASS Networks
www.iglass.net <http://www.iglass.net>

--
Adrian Klaver
adrian.kla...@aklaver.com