Bug #40825 for DBIx-Class-Schema-Loader: Apply quote chars on table names

Mon Nov 10 20:27:03 2008 JKRAMER [...] cpan.org - Ticket created

Subject:

Apply quote chars on table names

Some databases allow the use of special words as table names, when quoted properly (e.g., a table "group" can be created in Pg and SQLite). DBIx::Class::Schema::Loader doesn't properly quote table names, which makes it crash when encountering such a table. This can be fixed by calling $self->schema->storage->sql_maker->quote_char($self->{_quoter}); somewhere in DBIx::Class::Schema::Loader::DBI.

Tue Nov 11 13:25:11 2008 JKRAMER [...] cpan.org - Correspondence added

On Mon Nov 10 20:27:03 2008, jkramer wrote: Show quoted text

> Some databases allow the use of special words as table names, when > quoted properly (e.g., a table "group" can be created in Pg and SQLite). > DBIx::Class::Schema::Loader doesn't properly quote table names, which > makes it crash when encountering such a table. This can be fixed by

calling Show quoted text

> > $self->schema->storage->sql_maker->quote_char($self->{_quoter}); > > somewhere in DBIx::Class::Schema::Loader::DBI.

I forgot to mention that name_sep has to be set too. $self->schema->storage->sql_maker->quote_sep($self->{_namesep});

Tue Nov 11 13:25:14 2008 JKRAMER [...] cpan.org - Status changed from 'new' to 'open'

Sat Apr 10 09:00:14 2010 rkitover [...] cpan.org - Correspondence added

IIRC, this works fine now, as of 0.06000, closing. Reopen if you still have issues.

Sat Apr 10 09:00:16 2010 rkitover [...] cpan.org - Status changed from 'open' to 'resolved'