On Apr 2, 2007, at 1:31 AM, Jonathan Vanasco wrote:
>
> Lots of messages like this:
>
> Could not auto-retrieve unique keys for class
> XXXXX::RoseDB::Object::XXXXX - No columns found for relation id
> 174592, column numbers 0 at /Library/Perl/5.8.6/Rose/DB/Object/
> Metadata/Auto/Pg.pm line 111.
> at /Library/Perl/5.8.6/Rose/DB/Object/Loader.pm line 889
>
> whenever there's a unique index in play.
>
> drop the unique index -- and it generates fine
testing some more, i found out that this happens only on a function
index
ie:
works:
CREATE UNIQUE INDEX email_uidx ON table(email)
breaks:
CREATE UNIQUE INDEX email_uidx ON table(lower(email))
sorry for the confusion.
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
