Re: Slight modification to PostgreSQL address table definition

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> "Robert Smith", "Bob Smith", "Bobby", "Mr. Smith" and "Brad Jr." can be
> same
> person.

Yes, of course.  But "Mom" is pretty much the same for everyone.  ;)

> SquirrelMail address book has only one requirement. Unique nickname per
> address book. Any other restriction is specific to storage backend and
> might
> create problems when you change your backend. If unique indexes increase
> load of your DB, you might consider making them not unique. If users hit
> artificial restriction in DB, they won't see SquirrelMail address book
> warning, they will see DB error.
>
> Documentation needs fixes. I am not DBA, but I suspect that setting unique
> 4
> key index not required by application is not good thing. Documentation
> could
> show several ways to do index stuff.

And that is all I am asking to have changed, the documentation.
:)  The four-key index works very well for me, but I agree that
it probably makes DBAs shudder.  All I am commenting on is that
the recommendation made in the documentation may not work the
way many users may expect.

That's all.  :)

Benny


-- 
"Well, we *could* hunt down the perpetrators, pool some $$, and
hire 3 or 4 baseball-bat wielding professional explainers to go
explain our position to them.  Figuring out how to do so without
breaking any laws is the tough part..."
                                 -- Valdis Kletnieks, 2009-01-23



------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users


[Index of Archives]     [Video For Linux]     [Yosemite News]     [Yosemite Photos]     [gtk]     [KDE]     [Cyrus SASL]     [Gimp on Windows]     [Steve's Art]     [Webcams]

  Powered by Linux