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

From: Nicole <nicole(dot)king464(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function
Date: 2015-11-04 16:39:17
Message-ID: 563A34B5.8060808@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nicole 2015-11-04 17:43:55 Version 9.4 CREATE FUNCTION - ERROR: type xxxx does not exist create function
Previous Message Andres Freund 2015-11-04 10:33:51 Re: Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby