[前][次][番号順一覧][スレッド一覧]

rails:576

From: Hiroyuki Adachi <adachi@t...>
Date: Fri, 4 Nov 2005 09:34:10 +0900
Subject: [rails:576] postgresqlでrakeすると出るエラー

rakeコマンドで出るエラーの意味と、対処法がわからず困っています。
以下の環境で、以下のような動作をしました。

OS VineLinux 3.2
Rails 0.14.2
rake, version 0.6.2
postgresql-server-7.4.8

%  createdb -O rails demo_development
%  createdb -O rails demo_test
%  createdb -O rails demo_production 

% cat users.sql
create table users (
  id SERIAL,
  name VARCHAR(20) NOT NULL,
  password VARCHAR(20) NOT NULL,
  primary key (id)
);
% psql demo_development <users.sql
% psql demo_test <users.sql
% psql demo_production <users.sql

% rails demo
% cd demo
% emacs config/database.yml
development:
  adapter: postgresql
  database: demo_development
  socket: /path/to/your/mysql.sock
  username: rails
  password: ******

# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
  adapter: postgresql
  database: demo_test
  socket: /path/to/your/mysql.sock
  username: rails
  password: ******

production:
  adapter: postgresql
  database: demo_production
  socket: /path/to/your/mysql.sock
  username: rails
  password: ******

$ rake
psql:db/development_structure.sql:19: NOTICE:  CREATE TABLE will create \
implicit sequence "users_id_seq" for "serial" column "users.id"
psql:db/development_structure.sql:28: NOTICE:  ALTER TABLE / ADD PRIMARY \
KEY will create implicit index "users_pkey" for table "users"
psql:db/development_structure.sql:36: ERROR:  must be owner of schema public

この最後の行のエラーです。「must be owner of schema public」
どうしたらいいのでしょうか。どなたか教えてください、よろしくお願いします。	

--
安達 広幸

--
ML: rails@r...
使い方: http://QuickML.com/
Web Site: http://wiki.fdiary.net/rails/
ML Archives: http://www.fdiary.net/ml/rails/

[前][次][番号順一覧][スレッド一覧]

->     576 2005-11-04 01:34 [adachi@t...         ] postgresqlでrakeすると出るエラー        
       581 2005-11-04 07:23 ┣[miyamuko@g...       ]                                       
       583 2005-11-04 08:25 ┃┣[adachi@t...         ]                                     
       584 2005-11-04 08:34 ┃┗[adachi@t...         ]                                     
       586 2005-11-04 09:27 ┗[adachi@t...         ]                                       
       587 2005-11-04 10:32  ┗[stoyan@g...         ]                                     
       588 2005-11-04 10:55   ┗[adachi@t...         ]                                   
       589 2005-11-04 11:21    ┗[moriq@m...          ]                                 
       593 2005-11-04 12:48     ┗[adachi@t...         ]                               
       594 2005-11-04 12:59      ┣[moriq@m...          ]                             
       597 2005-11-04 21:23      ┃┗[adachi@t...         ]                           
       599 2005-11-05 04:26      ┃ ┗[moriq@m...          ]                         
       706 2005-11-27 15:58      ┗[craftgear@a...      ] SoftwareDesign12月号の記事  
       707 2005-11-27 16:14       ┗[yu1@t...            ]                           
       709 2005-11-28 00:50        ┗[craftgear@a...      ]                         
       710 2005-11-28 02:38         ┗[yu1@t...            ]                       
       711 2005-11-28 02:59          ┗[craftgear@a...      ]