thr3ads.net - Rails - Execute additional commands after creating database? [Aug 2007]

If this information is useful, please help other people find it:
Share via:

Martin Maciaszek

2007-Aug-07 06:26 UTC

Execute additional commands after creating database?

I''m writing some code that accesses some lagacy database on
PostgreSQL. Since the old database had some really ughly and weird
naming conventions (like CamelCase). To work around this I created a
second schema (named rails) in the same database and gave the tables
and fields some rails-friendly names. The database user that Rails
uses has its search_path set to the rails schema. That way Rails won''t
try to find models for the legacy tables. This worked fine so far. I
even got triggers working to be able to write into the real tables.

Now I installed RSpec and tried running some tests. This failed
because the test database gets recreated on every test run. Since I
specified config.active_record.table_name_prefix to be "rails." and a
fresh database doesn''t contain that schema yet it fails miserably. I
tried executing a "create schema rails" in the first migration but
somehow Globalize bit me in my ass because it tries to create it''s own
tables first although there is no such migration in db/migrations.
What can I do?

To illustrate, this is what it looks like.

% rake spec --trace
(in /Users/fastjack/Sites/rpps)
** Invoke spec (first_time)
** Invoke db:test:prepare (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:test:prepare
** Invoke db:test:clone (first_time)
** Invoke db:schema:dump (first_time)
** Invoke environment
** Execute db:schema:dump
** Invoke db:test:purge (first_time)
** Invoke environment
** Execute db:test:purge
** Execute db:test:clone
** Invoke db:schema:load (first_time)
** Invoke environment
** Execute db:schema:load
rake aborted!
PGError: ERROR:  schema "rails" does not exist
: CREATE TABLE rails.globalize_countries ("id" serial primary key,
"code" character varying(2) DEFAULT NULL, "english_name"
character
varying(255) DEFAULT NULL, "date_format" character varying(255)
DEFAULT NULL, "currency_format" character varying(255) DEFAULT NULL,
"currency_code" character varying(3) DEFAULT NULL,
"thousands_sep"
character varying(2) DEFAULT NULL, "decimal_sep" character varying(2)
DEFAULT NULL, "currency_decimal_sep" character varying(2) DEFAULT
NULL, "number_grouping_scheme" character varying(255) DEFAULT NULL)
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/connection_adapters/abstract_adapter.rb:128:in `log''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/connection_adapters/postgresql_adapter.rb:152:in
`execute''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/connection_adapters/abstract/schema_statements.rb:104:in
`create_table''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/migration.rb:275:in `send''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/migration.rb:275:in `method_missing''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/migration.rb:259:in `say_with_time''
/usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/migration.rb:259:in `say_with_time''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/migration.rb:273:in `method_missing''
./db/schema.rb:7
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/schema.rb:43:in `instance_eval''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
active_record/schema.rb:43:in `define''
./db/schema.rb:5
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/
lib/../../activesupport/lib/active_support/dependencies.rb:488:in
`load''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/
lib/../../activesupport/lib/active_support/dependencies.rb:488:in
`load''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/
lib/../../activesupport/lib/active_support/dependencies.rb:342:in
`new_constants_in''
/Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/
lib/../../activesupport/lib/active_support/dependencies.rb:488:in
`load''
/Users/fastjack/Sites/rpps/config/../vendor/rails/railties/lib/tasks/
databases.rake:31
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`execute''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`execute''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in
`invoke''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
`synchronize''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
`invoke''
/Users/fastjack/Sites/rpps/config/../vendor/rails/railties/lib/tasks/
databases.rake:76
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`execute''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`execute''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in
`invoke''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
`synchronize''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
`invoke''
/Users/fastjack/Sites/rpps/config/../vendor/rails/railties/lib/tasks/
databases.rake:153
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`execute''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`execute''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in
`invoke''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
`synchronize''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
`invoke''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:369:in
`invoke_prerequisites''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in
`each''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in
`send''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in
`each''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:368:in
`invoke_prerequisites''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:361:in
`invoke''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
`synchronize''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
`invoke''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in
`top_level''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in
`each''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in
`top_level''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in
`standard_exception_handling''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in
`top_level''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in
`standard_exception_handling''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run''
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7
/usr/local/bin/rake:16:in `load''
/usr/local/bin/rake:16


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

David Chelimsky

2007-Aug-07 19:32 UTC

head link

Re: Execute additional commands after creating database?

On 8/7/07, Martin Maciaszek
<fastjack-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:>
> I''m writing some code that accesses some lagacy database on
> PostgreSQL. Since the old database had some really ughly and weird
> naming conventions (like CamelCase). To work around this I created a
> second schema (named rails) in the same database and gave the tables
> and fields some rails-friendly names. The database user that Rails
> uses has its search_path set to the rails schema. That way Rails
won''t
> try to find models for the legacy tables. This worked fine so far. I
> even got triggers working to be able to write into the real tables.
>
> Now I installed RSpec and tried running some tests.
Have you successfully run any tests using rails baked-in testing?
> This failed
> because the test database gets recreated on every test run. Since I
> specified config.active_record.table_name_prefix to be "rails."
and a
> fresh database doesn''t contain that schema yet it fails miserably.
I
> tried executing a "create schema rails" in the first migration
but
> somehow Globalize bit me in my ass because it tries to create it''s
own
> tables first although there is no such migration in db/migrations.
> What can I do?
>
> To illustrate, this is what it looks like.
>
> % rake spec --trace
> (in /Users/fastjack/Sites/rpps)
> ** Invoke spec (first_time)
> ** Invoke db:test:prepare (first_time)
> ** Invoke environment (first_time)
> ** Execute environment
> ** Execute db:test:prepare
> ** Invoke db:test:clone (first_time)
> ** Invoke db:schema:dump (first_time)
> ** Invoke environment
> ** Execute db:schema:dump
> ** Invoke db:test:purge (first_time)
> ** Invoke environment
> ** Execute db:test:purge
> ** Execute db:test:clone
> ** Invoke db:schema:load (first_time)
> ** Invoke environment
> ** Execute db:schema:load
> rake aborted!
> PGError: ERROR:  schema "rails" does not exist
> : CREATE TABLE rails.globalize_countries ("id" serial primary
key,
> "code" character varying(2) DEFAULT NULL,
"english_name" character
> varying(255) DEFAULT NULL, "date_format" character varying(255)
> DEFAULT NULL, "currency_format" character varying(255) DEFAULT
NULL,
> "currency_code" character varying(3) DEFAULT NULL,
"thousands_sep"
> character varying(2) DEFAULT NULL, "decimal_sep" character
varying(2)
> DEFAULT NULL, "currency_decimal_sep" character varying(2) DEFAULT
> NULL, "number_grouping_scheme" character varying(255) DEFAULT
NULL)
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/connection_adapters/abstract_adapter.rb:128:in `log''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/connection_adapters/postgresql_adapter.rb:152:in
> `execute''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/connection_adapters/abstract/schema_statements.rb:104:in
> `create_table''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/migration.rb:275:in `send''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/migration.rb:275:in `method_missing''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/migration.rb:259:in `say_with_time''
> /usr/local/lib/ruby/1.8/benchmark.rb:293:in `measure''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/migration.rb:259:in `say_with_time''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/migration.rb:273:in `method_missing''
> ./db/schema.rb:7
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/schema.rb:43:in `instance_eval''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/lib/
> active_record/schema.rb:43:in `define''
> ./db/schema.rb:5
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/
> lib/../../activesupport/lib/active_support/dependencies.rb:488:in
> `load''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/
> lib/../../activesupport/lib/active_support/dependencies.rb:488:in
> `load''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/
> lib/../../activesupport/lib/active_support/dependencies.rb:342:in
> `new_constants_in''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/activerecord/
> lib/../../activesupport/lib/active_support/dependencies.rb:488:in
> `load''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/railties/lib/tasks/
> databases.rake:31
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`call''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
> `execute''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`each''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
> `execute''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in
> `invoke''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
> `synchronize''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
> `invoke''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/railties/lib/tasks/
> databases.rake:76
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`call''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
> `execute''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`each''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
> `execute''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in
> `invoke''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
> `synchronize''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
> `invoke''
> /Users/fastjack/Sites/rpps/config/../vendor/rails/railties/lib/tasks/
> databases.rake:153
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`call''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
> `execute''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
`each''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in
> `execute''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in
> `invoke''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
> `synchronize''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
> `invoke''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:369:in
> `invoke_prerequisites''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in
> `each''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in
> `send''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1003:in
> `each''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:368:in
> `invoke_prerequisites''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:361:in
> `invoke''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
> `synchronize''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in
> `invoke''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in
> `top_level''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in
> `each''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in
> `top_level''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in
> `standard_exception_handling''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in
> `top_level''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in
`run''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in
> `standard_exception_handling''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in
`run''
> /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7
> /usr/local/bin/rake:16:in `load''
> /usr/local/bin/rake:16
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Martin Maciaszek

2007-Aug-08 07:06 UTC

head link

Re: Execute additional commands after creating database?

On Aug 7, 9:32 pm, "David Chelimsky"
<dchelim...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> On 8/7/07, Martin Maciaszek
<fastj...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
[...]> > Now I installed RSpec and tried running some tests.
>
> Have you successfully run any tests using rails baked-in testing?
I never used them before. I tried running them now and got the same
error.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Roderick van Domburg

2007-Aug-08 07:35 UTC

head link

Re: Execute additional commands after creating database?

Martin Maciaszek wrote:> Now I installed RSpec and tried running some tests. This failed
> because the test database gets recreated on every test run. Since I
> specified config.active_record.table_name_prefix to be "rails."
and a
> fresh database doesn''t contain that schema yet it fails miserably.
I
> tried executing a "create schema rails" in the first migration
but
> somehow Globalize bit me in my ass because it tries to create it''s
own
> tables first although there is no such migration in db/migrations.
> What can I do?
I agree that it can be pretty irritating. One thing you can do is create 
your database and schema with a different owner and then grant all 
privileges on the schema to the user that Rails is set to. That''ll
cause
createdb and dropdb to fail yet still allow you to create and drop 
tables.

--
Roderick van Domburg
http://www.nedforce.nl
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Martin Maciaszek

2007-Aug-09 07:05 UTC

head link

Re: Execute additional commands after creating database?

On Aug 8, 9:35 am, Roderick van Domburg <rails-mailing-l...@andreas-
s.net> wrote:> Martin Maciaszek wrote:
> > Now I installed RSpec and tried running some tests. This failed
> > because the test database gets recreated on every test run. Since I
> > specified config.active_record.table_name_prefix to be
"rails." and a
> > fresh database doesn''t contain that schema yet it fails
miserably. I
> > tried executing a "create schema rails" in the first
migration but
> > somehow Globalize bit me in my ass because it tries to create
it''s own
> > tables first although there is no such migration in db/migrations.
> > What can I do?
>
> I agree that it can be pretty irritating. One thing you can do is create
> your database and schema with a different owner and then grant all
> privileges on the schema to the user that Rails is set to. That''ll
cause
> createdb and dropdb to fail yet still allow you to create and drop
> tables.
Well, it started promising but then got ughly. I''m not quite sure what
exactly went wrong but I suspect it''s globalize''s fault.

Here''s the log:
** Invoke spec (first_time)
** Invoke db:test:prepare (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:test:prepare
** Invoke db:test:clone (first_time)
** Invoke db:schema:dump (first_time)
** Invoke environment
** Execute db:schema:dump
** Invoke db:test:purge (first_time)
** Invoke environment
** Execute db:test:purge
dropdb: database removal failed: ERROR:  must be owner of database
rpps_test
createdb: database creation failed: ERROR:  permission denied to
create database
** Execute db:test:clone
** Invoke db:schema:load (first_time)
** Invoke environment
** Execute db:schema:load
NOTICE:  CREATE TABLE will create implicit sequence
"globalize_countries_id_seq" for serial column
"globalize_countries.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"globalize_countries_pkey" for table "globalize_countries"
rake aborted!
PGError: ERROR:  duplicate key violates unique constraint
"pg_attribute_relid_attnam_index"
: CREATE  INDEX "index_globalize_countries_on_code" ON
rpps.globalize_countries ("code", "code")

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Seemingly Similar Threads

Search for more seemingly similar threads

Rails - Aug 2007 - Execute additional commands after creating database?

Execute additional commands after creating database?

Re: Execute additional commands after creating database?

Re: Execute additional commands after creating database?

Re: Execute additional commands after creating database?

Re: Execute additional commands after creating database?

Seemingly Similar Threads