Re: Scheduling jobs

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of 
> Poul Møller Hansen
> Sent: 17 February 2006 13:20
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Scheduling jobs
> 
> 
> >The schema needs to be in your maintenance DB (ie. The one 
> pgAdmin initially connects to). My guess is that you put it 
> someplace else.
> >
> >  
> >
> ahh, now it works :)
> 
> How can I get with of the pgagent schema in the other database again ?
> I get the message "Cannot drop system Schema pgagent"

Ahh, that you be pgAdmin protecting you from yourself :-)

Try the following in a Query Tool (in the appropriate database):

DROP SCHEMA pgagent CASCADE;

Regards, Dave.