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... ]