biddyweb / substruct

Automatically exported from code.google.com/p/substruct
0 stars 0 forks source link

rake substruct:db:bootstrap not working with postgresql #132

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. create and configure postgresql db
2. rake substruct:db:bootstrap
3.

What is the expected output? What do you see instead?
expected: NO error messages.
actual: (creates some tables....)
-- add_index("order_addresses", ["first_name", "last_name"], {:name=>"name"})
rake aborted!
PGError: FEHLER:  Relation »name« existiert bereits
: CREATE  INDEX "name" ON "order_addresses" ("first_name", "last_name")

What version of the product are you using? On what operating system?

substruct-1.0a6, postgresql-8.3, Ubuntu 

Please provide any additional information below.

I think it's not possible to have multiple indexes of the same name in the
DB. The supplied db/schema.rb creates an index called "name" for a number
of tables.

Original issue reported on code.google.com by kar...@gmail.com on 2 Sep 2008 at 7:58

GoogleCodeExporter commented 9 years ago
[deleted comment]
GoogleCodeExporter commented 9 years ago
there was a post recently to the group on postgres compat--does that fix it?

Original comment by rogerpack2005 on 30 Oct 2008 at 2:16

GoogleCodeExporter commented 9 years ago
It's fixed by the patch in #138.

Original comment by kar...@gmail.com on 30 Oct 2008 at 3:04