Creating a function in the postgresql database on heroku

Question

I'm trying to create a function on my Heroku database. I'll eventually tie it to a trigger.

I've seen the error all over, but I can't seem to see a way around it.

The error I get is...

rake aborted!
PG::Error: ERROR:  language "plpgsql" does not exist

What I'm reading is that I can't create triggers or functions on heroku. Unless I go with the shared_database, which is not an option. My app is already multi-tenanted, and makes use of it's own schemas.

I attempted to create the language as suggested, but that is denied.

Question: Am I reading things right, can one create functions in postgesql on heroku?
Question: If one can make functions in the database, then does anyone know how?

You're using the shared database, right? I have lots of functions and triggers defined in a dedicated Heroku database. — mu is too short
– mu is too short, Commented Jun 4, 2012 at 1:26
turns out I am indeed using the shared. Most confusing, because I am able to create different schemas.. Or I was in the past. — baash05
– baash05, Commented Jun 4, 2012 at 2:07

Erwin Brandstetter · Accepted Answer · 2013-12-03 16:04:05Z

5

Since PostgreSQL 9.0 the procedural language PL/pgSQL is pre-installed. On earlier versions you have to run:

CREATE LANGUAGE plpgsql;

once per database. Heroku shared may still be PostgreSQL 8.3. More in the fine manual.

However, the old "shared" plan does not allow plpgsql, as far as I have heard (don't use it myself). There is a new plan with PostgreSQL 9.1 , supporting plpgsql, though.

edited Dec 3, 2013 at 16:04

answered Jun 4, 2012 at 10:49

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

remvee Over a year ago

I can confirm the basic heroku plan does not let you do "CREATE language plpgsql"

Erwin Brandstetter Over a year ago

@anka: Double quotes are not needed for plpgsql here. Try the fine manual.

Collectives™ on Stack Overflow

Creating a function in the postgresql database on heroku

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related