Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function - Mailing list pgsql-bugs

From Nicole
Subject Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function
Date
Msg-id 563A34B5.8060808@gmail.com
Whole thread Raw
Responses Re: Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function  (Joe Conway <mail@joeconway.com>)
List pgsql-bugs
Given this function body:

DECLARE
   recurrence Client_Appointment_Recurrences;
   ...
BEGIN
   ...
END

and a table called "Client_Appointment_Recurrences", the message is
"ERROR: type client_appointment_recurrences does not exist".

Rename the table to "client_appointment_recurrences" and the error vanishes

Regards

Nicole

pgsql-bugs by date:

Previous
From: breen@rtda.com
Date:
Subject: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled
Next
From: Nicole
Date:
Subject: Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function