Re: [RDBO] Loader primary key confusion

2007-02-27 Thread Fred Cox
--- 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: Can you post the CREATE TABLE statement CREATE TABLE ratings ( userid integer NOT NULL

Re: [RDBO] Loader primary key confusion

2007-02-27 Thread John Siracusa
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

Re: [RDBO] Loader primary key confusion

2007-02-27 Thread Fred Cox
--- 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