mtmatos Posted May 29, 2011 Posted May 29, 2011 Hi! I am using PostGreSQL and I need to create a procedural language (plpgsql) to create my functions, but when I try to do it I see the following message: "Must be superuser to create procedural language". So, is it possible to create p.language for my database?
jje Posted May 29, 2011 Posted May 29, 2011 This support request is being escalated to our root admin.
jje Posted May 29, 2011 Posted May 29, 2011 Username: same as HelioNet Domain: revisaosolidaria.heliohost.org Server: Johnny This support request is being escalated to our root admin.
Guest Geoff Posted May 29, 2011 Posted May 29, 2011 See also http://www.helionet.org/index/index.php?sh...&hl=plpgsql
mtmatos Posted May 30, 2011 Author Posted May 30, 2011 See also http://www.helionet.org/index/index.php?sh...&hl=plpgsql Geoff, I've read the topic and it seems that you had to execute the command CREATE LANGUAGE plpgsql; as root. If you could do the same in my database I'd appreciate.
jje Posted May 31, 2011 Posted May 31, 2011 Only djbob can run this command. Let's see... This support request is being escalated to our root admin.
Guest Geoff Posted May 31, 2011 Posted May 31, 2011 This support request is being escalated to our root admin. What? This topic was already escalated. Why did you re-escalate this thread?
Krydos Posted May 31, 2011 Posted May 31, 2011 This support request is being escalated to our root admin. This support request is being escalated to our root admin. This support request is being escalated to our root admin. What? This topic was already escalated. Why did you re-escalate this thread? [TV Announcer Voice] HelioHost. Now with triple the escalation power. Offer only valid at participating sites. Void where prohibited by law and offer has no cash value. [/End TV Announcer Voice]
Ashoat Posted May 31, 2011 Posted May 31, 2011 I already tried running the CREATE LANGUAGE command, along with the commands specified in the other thread. It seems like I can't create the language for other users without granting them "superuser" privileges, which I don't want to do. Does anyone have any ideas as to what I can do?
jje Posted June 1, 2011 Posted June 1, 2011 This support request is being escalated to our root admin. This support request is being escalated to our root admin. This support request is being escalated to our root admin. What? This topic was already escalated. Why did you re-escalate this thread? [TV Announcer Voice] HelioHost. Now with triple the escalation power. Offer only valid at participating sites. Void where prohibited by law and offer has no cash value. [/End TV Announcer Voice] Oops, lol
mtmatos Posted June 1, 2011 Author Posted June 1, 2011 Okay, done. Is it working now? Not yet. I tried to create a function but the following message appears: ERROR: language "plpgsql" does not exist
Guest Geoff Posted June 1, 2011 Posted June 1, 2011 I'm out of ideas. Maybe you could give some suggestions.
Recommended Posts