From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | Poul Møller Hansen <freebsd(at)pbnet(dot)dk>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Scheduling jobs |
Date: | 2006-02-17 13:26:16 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40103E1B2@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Poul Møller Hansen | 2006-02-17 13:41:40 | Re: Scheduling jobs |
Previous Message | Poul Møller Hansen | 2006-02-17 13:20:20 | Re: Scheduling jobs |