Re: Postgres with phpScheduleIt

On Thu, 2009-03-05 at 14:08 -0500, Tom Lane wrote:
> Stuart Luppescu <slu(at)ccsr(dot)uchicago(dot)edu> writes:
> > phpScheduleIt uses mySQL by default, but they claim is should work with
> > postgres. The setup uses a script that starts like this:
>
> > # phpScheduleIt 1.2.0 #
> > drop database if exists phpScheduleIt;
> > create database phpScheduleIt;
> > use phpScheduleIt;
>
> Frankly, it looks like you shouldn't believe their claim that they work
> with postgres. The "use" bit is 100% mysql-specific, and we haven't
> even got into the part of things that is likely to have database
> dependencies. While it might not be difficult for someone who's
> reasonably familiar with both DBs to fix things up, that's evidently not
> you. Your best bet would probably be to either use mysql like they tell
> you to, or find another scheduler package whose authors actually expend
> more than zero effort on working with postgres.

Doesn't pgAdmin have a scheduler?

Joshua D. Drake

>
> regards, tom lane
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997