[ic] [interchange] Fix error creating indexes in Postgres when QUOTE_IDENTIFIERS is set

Peter peter at pajamian.dhs.org
Tue Mar 8 08:26:42 UTC 2016


On 08/03/16 18:00, Jon Jensen wrote:
>     Fix error creating indexes in Postgres when QUOTE_IDENTIFIERS is set
>     
>     The problem was that Vend::Table::DBI was assembling an index name
>     based on the quoted table name plus '_' plus quoted column name,
>     resulting in a syntactically invalid name like "variants"_"sku",

>     Instead assemble the name unquoted, and quote the final result.

Good catch, thanks Jon.


Peter



More information about the interchange-users mailing list