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

Peter <[email protected]> Tue, 8 Mar 2016 21:24:59 +1300
Newsgroups gmane.comp.web.interchange.cvs
Message-ID <[email protected]>
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