[BUGS] Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function

[Nicole]

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

[Nicole]

Further to previous message. I've found inconsistencies in case
sensitivity of this type in renaming a FOREIGN KEY CONSTRAINT.

[Joe Conway]

Post by Nicole
Further to previous message. I've found inconsistencies in case
sensitivity of this type in renaming a FOREIGN KEY CONSTRAINT.

As mentioned on the previous email, this is not a bug report. Please
post your questions to the novice or general mailing lists found here:

http://www.postgresql.org/community/lists/

Additionally please see this link before posting:

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

HTH,

Joe

[Joe Conway]

Post by Nicole
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