Re: Mixed-case column names breaking under Class::DBI

Are you using a sequence on it? Alla __PACKAGE__->sequence('cd_id_seq'). I think you need to do that for Pg but I could be wrong. You also might give Class::DBI::Pg (has sample code for non-CDBI::Pg use too) a try as the base instead, just to see if it makes any difference.

Comment on Re: Mixed-case column names breaking under Class::DBI Download Code

Replies are listed 'Best First'.
Re^2: Mixed-case column names breaking under Class::DBI by sintadil (Pilgrim) on Sep 21, 2004 at 02:31 UTC
Are you using a sequence on it? Alla `__PACKAGE__->sequence('cd_id_seq')`. I think you need to do that for Pg but I could be wrong. Good observation, but I'm not using any such data type in the particular table that I tried testing. You also might give Class::DBI::Pg (has sample code for non-CDBI::Pg use too) a try as the base instead, just to see if it makes any difference. Yet another good suggestion, but it results in the same syntax error as before because it's not properly quoting the User column.	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Mixed-case column names breaking under Class::DBI
by sintadil (Pilgrim) on Sep 21, 2004 at 02:31 UTC

Are you using a sequence on it? Alla __PACKAGE__->sequence('cd_id_seq'). I think you need to do that for Pg but I could be wrong.

Good observation, but I'm not using any such data type in the particular table that I tried testing.

You also might give Class::DBI::Pg (has sample code for non-CDBI::Pg use too) a try as the base instead, just to see if it makes any difference.

Yet another good suggestion, but it results in the same syntax error as before because it's not properly quoting the User column.

[reply]
[d/l]