You are right.. with mysql works fine, but with postgresql I got the same error. I have opened a ticket as you do not have a trac account.
http://trac.symfony-project.com/trac/ticket/1720 regards, Rimenes Ribeiro. On Apr 27, 6:20 am, Alexander Deruwe <[EMAIL PROTECTED]> wrote: > On 27 Apr 2007, at 04:07, Rimenes Ribeiro wrote: > > > Hello Alexander, > > I've took a look at the latest version of sfGuardPlugin and found > > two constraints named 'unique_name' but in two different tables > > (sfGuardGroup and sfGuardPermission). If you are talking about those > > two constraints it's normal and completely possible as they are in > > different tables. > > 11:10:50 [EMAIL PROTECTED]:~ $ createdb idxtest > CREATE DATABASE > 11:11:16 [EMAIL PROTECTED]:~ $ psql idxtest > Welcome to psql 7.4.13, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? for help on internal slash commands > \g or terminate with semicolon to execute query > \q to quit > > idxtest=# create table test (id integer); > CREATE TABLE > idxtest=# create table test2 (id integer); > CREATE TABLE > idxtest=# create index idx_test on test (id); > CREATE INDEX > idxtest=# create index idx_test on test2 (id); > ERROR: relation "idx_test" already exists > idxtest=# > > So maybe it works on some databases (I'm thinking MySQL?), but at > least PostgreSQL 7.4 does not like indexes with the same name... > Incidentallly, PostgreSQL is what I am using. > > Alexander --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
