Need help - got errors executing database.sql

Hi

Well, I compiled mrproject 0.10pre, and began following the steps in
the README file to configure the postgresql database, and with a bit
of struggling due to my lack of knowledge, got up to the last step,
where all hell broke loose.

Can you help me figure out what went wrong?  This is just a sample of
the errors I got.  I'm not including the whole thing because its
pretty long and fairly repetitive in the nature of the errors.

Thanks!

[Kurt@Kronk Kurt]$ cat database.sql | psql -e -U kurt -d mrprojectdb
CREATE TABLE project (
        proj_id          serial,
        name             text NOT NULL,
        company          text,
        manager          text,
        proj_start       date NOT NULL DEFAULT now(),
        cal_id           integer,
        phase            text,
        default_group_id integer,
        revision         integer,
        last_user        text NOT NULL DEFAULT user(),
        PRIMARY KEY (proj_id)
);
ERROR:  parser: parse error at or near "(" at character 320
GRANT select,insert,update,delete ON project TO GROUP mrproject;
ERROR:  Relation "project" does not exist
GRANT select,update ON project_proj_id_seq TO GROUP mrproject;
ERROR:  Relation "project_proj_id_seq" does not exist
CREATE TABLE phase (
        phase_id        serial,
        proj_id         integer,
        name            text NOT NULL,
        FOREIGN KEY (proj_id) REFERENCES project (proj_id)
                ON DELETE CASCADE ON UPDATE CASCADE,
        PRIMARY KEY (phase_id)
);
NOTICE:  CREATE TABLE will create implicit sequence
'phase_phase_id_seq' for SERIAL column 'phase.phase_id'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'phase_pkey' for table 'phase'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR:  Relation "project" does not exist
GRANT select,insert,update,delete ON phase TO GROUP mrproject;
ERROR:  Relation "phase" does not exist
GRANT select,update ON phase_phase_id_seq TO GROUP mrproject;
ERROR:  Relation "phase_phase_id_seq" does not exist
CREATE TABLE daytype (
        dtype_id        serial,
        proj_id         integer,
        name            text,
        descr           text,
        is_work         boolean NOT NULL DEFAULT FALSE,
        is_nonwork      boolean NOT NULL DEFAULT FALSE,
        UNIQUE (proj_id, name),
        FOREIGN KEY (proj_id) REFERENCES project (proj_id)
                ON DELETE CASCADE ON UPDATE CASCADE,
        PRIMARY KEY (dtype_id)
);
NOTICE:  CREATE TABLE will create implicit sequence
'daytype_dtype_id_seq' for SERIAL column 'daytype.dtype_id'
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'daytype_pkey' for table 'daytype'NOTICE:  CREATE TABLE / UNIQUE will
create implicit index 'daytype_proj_id_key' for table 'daytype'
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
ERROR:  Relation "project" does not exist
GRANT select,insert,update,delete ON daytype TO GROUP mrproject;
ERROR:  Relation "daytype" does not exist
GRANT select,update ON daytype_dtype_id_seq TO GROUP mrproject;
ERROR:  Relation "daytype_dtype_id_seq" does not exist


=====
Kurt Maute
[email protected]

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com