From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Message-ID: <3F9D1227.4030606@psv.com.ua> Date: Mon, 27 Oct 2003 14:40:07 +0200 From: Slava Dubrovskiy User-Agent: Mozilla/5.0 (X11; U; Linux i686; ru-RU; rv:1.4) Gecko/20030710 X-Accept-Language: ru-ru, ru MIME-Version: 1.0 To: community@altlinux.ru Subject: Re: [Comm] Packhouse References: <3F991037.1010100@psv.com.ua> <169432569171.20031027105306@omsk-gsm.ru> In-Reply-To: <169432569171.20031027105306@omsk-gsm.ru> X-Enigmail-Version: 0.76.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 8bit X-BeenThere: community@altlinux.ru X-Mailman-Version: 2.1.2 Precedence: list Reply-To: community@altlinux.ru List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 27 Oct 2003 12:35:44 -0000 X-List-Received-Date: Mon, 27 Oct 2003 12:35:44 -0000 Archived-At: List-Archive: List-Post: Dmitry Chernyakov пишет: >Dear Slava, > >reply:Friday, October 24, 2003 > >SD> Кто-то реально работает в Packhouse? Поделитесь опытом, возможна ли >SD> реальная работа, какие подводные камни есть? Почему при установке базы >SD> инициализация базы происходит с ошибками? > >Я работаю. Реальная работа возможна. > >Приведи ошибки, помогу. > Например вот с самого начала: [slava@server sql]$ ./newdb Вы теперь подсоединены к базе данных template1 как пользователь postgres. CREATE USER Вы теперь подсоединены как новый пользователь keeper. CREATE DATABASE CREATE USER Вы теперь подсоединены к базе данных packhouse как пользователь keeper. psql:c_agent.sql:1: ERROR: sequence "agent_id_seq" does not exist psql:c_agent.sql:2: ERROR: index "agent_deleted_key" does not exist psql:c_agent.sql:3: ERROR: index "agent_id_key" does not exist psql:c_agent.sql:4: ERROR: table "agent" does not exist psql:c_agent.sql:20: NOTICE: CREATE TABLE will create implicit sequence 'agent_id_seq' for SERIAL column 'agent.id' CREATE TABLE COMMENT CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX GRANT psql:c_agent.sql:29: ERROR: view "supplier" does not exist CREATE VIEW GRANT psql:c_agent.sql:34: ERROR: view "recipient" does not exist CREATE VIEW GRANT INSERT 34013 1 INSERT 34014 1 INSERT 34015 1 INSERT 34016 1 INSERT 34017 1 INSERT 34018 1 INSERT 34019 1 psql:c~bodymore.sql:2: ERROR: index "bodymore_id_key" does not exist psql:c~bodymore.sql:3: ERROR: table "bodymore" does not exist psql:c~bodymore.sql:15: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) psql:c~bodymore.sql:15: ERROR: Relation "body" does not exist psql:c~bodymore.sql:16: ERROR: Relation "bodymore" does not exist psql:c~bodymore.sql:17: ERROR: Relation "bodymore" does not exist psql:c~bodymore.sql:18: ERROR: Relation "bodymore" does not exist psql:c_body.sql:1: ERROR: sequence "body_id_seq" does not exist psql:c_body.sql:2: ERROR: index "body_deleted_key" does not exist psql:c_body.sql:3: ERROR: index "body_document_key" does not exist psql:c_body.sql:4: ERROR: index "body_id_key" does not exist psql:c_body.sql:5: ERROR: table "body" does not exist psql:c_body.sql:21: NOTICE: CREATE TABLE will create implicit sequence 'body_id_seq' for SERIAL column 'body.id' CREATE TABLE COMMENT CREATE INDEX CREATE INDEX GRANT psql:c_class.sql:1: ERROR: sequence "class_id_seq" does not exist psql:c_class.sql:2: ERROR: index "class_deleted_key" does not exist psql:c_class.sql:3: ERROR: index "class_id_key" does not exist psql:c_class.sql:4: ERROR: table "class" does not exist psql:c_class.sql:13: NOTICE: CREATE TABLE will create implicit sequence 'class_id_seq' for SERIAL column 'class.id' CREATE TABLE COMMENT CREATE INDEX GRANT psql:c~client.sql:1: ERROR: table "client" does not exist CREATE TABLE COMMENT psql:c_config.sql:1: ERROR: sequence "config_id_seq" does not exist psql:c_config.sql:2: ERROR: index "config_id_key" does not exist psql:c_config.sql:3: ERROR: table "config" does not exist psql:c_config.sql:11: NOTICE: CREATE TABLE will create implicit sequence 'config_id_seq' for SERIAL column 'config.id' CREATE TABLE и т.д. А дальше естественно не работают запросы в броузере. Слава Д.