Forum OpenACS Q&A: Re: trackack cuases weblogger to crash

Collapse
Posted by Hans Gaasenbeek on
I manually ran this:
service0@CP14105-A:/var/lib/aolserver/service0/packages/lars-blogger/sql/postgresql$ psql -f lars-blogger-categories-create.sql service0

This created:

psql:lars-blogger-categories-create.sql:21: WARNING:  Error occurred while executing PL/pgSQL function acs_object_type__create_type
psql:lars-blogger-categories-create.sql:21: WARNING:  line 37 at SQL statement
psql:lars-blogger-categories-create.sql:21: ERROR:  Cannot insert a duplicate key into unique index acs_object_types_pk
psql:lars-blogger-categories-create.sql:34: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'pinds_blog_categories_pk' for table 'pinds_blog_categories'
psql:lars-blogger-categories-create.sql:34: NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
psql:lars-blogger-categories-create.sql:34: ERROR:  Relation 'pinds_blog_categories' already exists
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION