Thread: Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function

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

On 11/04/2015 08:39 AM, Nicole wrote:
> DECLARE
>   recurrence Client_Appointment_Recurrences;

This is not a bug and not the appropriate list for a question. That
said, try this:

8<------------------
CREATE TABLE "Client_Appointment_Recurrences" (id int);

CREATE OR REPLACE FUNCTION test() RETURNS text AS $$
DECLARE
  recurrence "Client_Appointment_Recurrences";
BEGIN
  RETURN 'ok';
END$$ LANGUAGE plpgsql;

SELECT test();
 test
------
 ok
(1 row)
8<------------------

HTH,

Joe

--=20
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development