I have created DB instance on RDS and used below function. It gave error while with the same PostgreSQL version on a local development machine it works fine.
create or replace function uuid() returns uuid as 'uuid-ossp', 'uuid_generate_v1' volatile strict language C;
here is the error log:
ERROR: permission denied for language c ********** Error ********** ERROR: permission denied for language c SQL state: 42501
I'm using this function in ruby on rails 3.2 for generating uuid for my schema.
You appear to be attempting to load uuid-ossp extension by loading the .sql file directly. You should not be doing that on any modern PostgreSQL, and it won't work on RDS.
CREATE EXTENSION "uuid-ossp";