mtmatos Posted May 29, 2011 Share 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? Link to comment Share on other sites More sharing options...
jje Posted May 29, 2011 Share Posted May 29, 2011 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 29, 2011 Share Posted May 29, 2011 Please post the server that you are on. Link to comment Share on other sites More sharing options...
jje Posted May 29, 2011 Share Posted May 29, 2011 Username: same as HelioNet Domain: revisaosolidaria.heliohost.org Server: Johnny This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 29, 2011 Share Posted May 29, 2011 See also http://www.helionet.org/index/index.php?sh...&hl=plpgsql Link to comment Share on other sites More sharing options...
mtmatos Posted May 30, 2011 Author Share 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. Link to comment Share on other sites More sharing options...
jje Posted May 31, 2011 Share Posted May 31, 2011 Only djbob can run this command. Let's see... This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 31, 2011 Share 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? Link to comment Share on other sites More sharing options...
Krydos Posted May 31, 2011 Share 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] Link to comment Share on other sites More sharing options...
Ashoat Posted May 31, 2011 Share 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? Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 31, 2011 Share Posted May 31, 2011 Did you try running CREATE TRUSTED LANGUAGE? Link to comment Share on other sites More sharing options...
Ashoat Posted June 1, 2011 Share Posted June 1, 2011 Okay, done. Is it working now? Link to comment Share on other sites More sharing options...
jje Posted June 1, 2011 Share 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 Link to comment Share on other sites More sharing options...
mtmatos Posted June 1, 2011 Author Share 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 Link to comment Share on other sites More sharing options...
Guest Geoff Posted June 1, 2011 Share Posted June 1, 2011 I'm out of ideas. Maybe you could give some suggestions. Link to comment Share on other sites More sharing options...
Recommended Posts