--- John Siracusa <[EMAIL PROTECTED]> wrote:
> 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.
>
Thanks for the fix!
Fred
> -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
> Rose-db-object@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/rose-db-object
>
____________________________________________________________________________________
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail
-------------------------------------------------------------------------
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
