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.klaver@xxxxxxxxxxx
