On 2/27/07, Fred Cox <[EMAIL PROTECTED]> wrote:
> Version 761 (latest in FreeBSD ports) RDBO::Loader chooses the wrong primary
> key for this PostgreSQL table:
The column name "year" is auto-quoted (probably a reserved word) and
wasn't being unquoted properly by Rose::DB. The fix is in SVN. The
diff is small enough that I've included it below. Thanks for the
report.
-John
Index: lib/Rose/DB.pm
===================================================================
--- lib/Rose/DB.pm (revision 1247)
+++ lib/Rose/DB.pm (working copy)
@@ -19,7 +19,7 @@
our $Error;
-our $VERSION = '0.733';
+our $VERSION = '0.734';
our $Debug = 0;
@@ -1247,7 +1247,7 @@
Carp::croak "Could not extract column name from DBI primary_key_info()";
}
- push(@columns, $pk_info->{'COLUMN_NAME'});
+ push(@columns, $self->unquote_column_name($pk_info->{'COLUMN_NAME'}));
}
return [EMAIL PROTECTED];
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
