Re: Hosting Account with PostgreSQL and PHP?

[Andre Lopes <lopes80andre@xxxxxxxxx>]

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.