On Mon, Feb 15, 2010 at 9:23 PM, Andre Lopes <lopes80andre@xxxxxxxxx> wrote: > I have contacted again the support center on a2hosting.com and the answer > was that is no manual creation of triggers on PostgreSQL, bu the guy have > send to me a link with MySQL information about the subject, > https://support.a2hosting.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=500 > > There are more a2hosting customers here that can create Triggers? > > > Best Regards, > > > > > On Mon, Feb 15, 2010 at 5:53 PM, Andre Lopes <lopes80andre@xxxxxxxxx> wrote: >> >> Hi, >> >> I have talk with the support. Here is the conversation: >> >> [quote] >> Matt T. - A2 Hosting Support: Hello, how may I help you today? >> André Lopes: I need to know if a2hosting allows Trigger creation in >> PostgreSQL databases >> Matt T. - A2 Hosting Support: Yes but our admins would need to create them >> for you via a support ticket >> [/quote] >> >> Maybe is for new customers. I will talk again with the support. >> >> Thanks. >> >> >> >> On Mon, Feb 15, 2010 at 5:44 PM, John DeSoi <desoi@xxxxxxxxxx> wrote: >>> >>> On Feb 15, 2010, at 11:25 AM, Andre Lopes wrote: >>> >>> > A2hosting.com supports Triggers, but in the WebHosting Plan and in the >>> > Reseller Plan the Triggers creation is not done by the user, we must send >>> > the Trigger to the support center and then they compile the Trigger... >>> >>> >>> Where did you hear this? I have a reseller account and I have created >>> many triggers using pl/pgsql. Are you wanting to create triggers with C or >>> some other language that requires superuser access? >>> >>> >>> >>> >>> John DeSoi, Ph.D. >>> >>> >>> >>> >> > > I have hosted with eApps (http://www.eapps.com/) for a while, they employ the virtual machine concept using parallels. The developer category of service plan may you get a "machine" and you get to be root. PostgreSQL, PHP, Java (including application containers such as Tomcat and JBoss) and so on are available. I find them reasonably priced. On the linux server they give you you may further install/build an software of your choice including maybe another instance of the latest PostgreSQL. Allan. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general