[Catalyst] A table called session

[Jason Woodward]

Hi Chisel,

> ---- cut here ----
>  exists
> "/home/chisel/development/tmp/new_sessions/App1/script/../lib/App1/Model"
>  exists
> "/home/chisel/development/tmp/new_sessions/App1/script/../t/Model"
>  exists
> "/home/chisel/development/tmp/new_sessions/App1/script/../lib/App1/Model/SomeDB.pm"
> Use of uninitialized value in split at
> /usr/lib/perl5/vendor_perl/5.8.5/Class/DBI/Pg.pm line 81.
> "session" has no primary key at
> /usr/lib/perl5/vendor_perl/5.8.7/Class/DBI/Loader/Generic.pm line 196
> ---- cut here ----
> 
> I create App2 in the same way, renamed the table to web_session, and the
> problem just went away.
> 
> I did a quick 'grep -r session
> /usr/lib/perl5/vendor_perl/5.8.7/Class/DBI/' but no results were
> returned.
> 
> 
> Has anyone else seen this? Is it Pg-specific? Can anyone else reproduce
> the error?
> I'd be interested to know is anyone has any ideas, or is this a
> CDBI-specific issue that should be taken to the CDBI list?


I had the same issue initially.  The table name is quoted by the caller of set_up_table.   I
added $table =~ s/['"]//g; prior to the call to prepare() and it the problem went away.


HTH,
jason

--
Jason Woodward
woodwardj at jaos.org