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 symfony-users@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
