Bug #63814 for SQL-Translator: PostgreSQL producer: create index using hash method

Fri Dec 10 16:11:58 2010 icestar [...] inbox.ru - Ticket created

Subject:

PostgreSQL producer: create index using hash method

Hello! I've read the documentation on SQL::Translator::Schema::Index module and couldn't understand how I should set the 'options' parameter to create index with the HASH method. I tried to set it like this: my $i1 = $table->add_index( name => 'name', fields => [ 'name' ], options => ['using' => 'hash'], ); but didn't get the expected result, index was created with B-tree method. Please, give me the right example and could you add it to the documentation for everyone.

Sun Dec 12 17:32:04 2010 icestar [...] inbox.ru - Correspondence added

From:

icestar [...] inbox.ru

On Fri Dec 10 16:11:58 2010, Alien wrote: Show quoted text

> Hello! > I've read the documentation on SQL::Translator::Schema::Index module and > couldn't understand how I should set the 'options' parameter to create > index with the HASH method. > I tried to set it like this: > > my $i1 = $table->add_index( > name => 'name', > fields => [ 'name' ], > options => ['using' => 'hash'], > ); > > but didn't get the expected result, index was created with B-tree method. > Please, give me the right example and could you add it to the > documentation for everyone.

I've looked into the code of SQL::Translator::Producer::PostgreSQL module and didn't find any ability to set using hash method. Am I right that it's not possible now to set index method?

Wed Apr 08 19:47:58 2015 sebastian [...] podjasek.pl - Correspondence added

From:

sebastian [...] podjasek.pl

On Nd 12 Gru 2010, 17:32:04, Alien wrote: Show quoted text

> On Fri Dec 10 16:11:58 2010, Alien wrote:

> > Hello! > > I've read the documentation on SQL::Translator::Schema::Index module and > > couldn't understand how I should set the 'options' parameter to create > > index with the HASH method. > > I tried to set it like this: > > > > my $i1 = $table->add_index( > > name => 'name', > > fields => [ 'name' ], > > options => ['using' => 'hash'], > > ); > > > > but didn't get the expected result, index was created with B-tree method. > > Please, give me the right example and could you add it to the > > documentation for everyone.

> > > I've looked into the code of SQL::Translator::Producer::PostgreSQL > module and didn't find any ability to set using hash method. Am I right > that it's not possible now to set index method?

Just created a pull request for this issue, if you're still interested after that much time: https://github.com/dbsrgits/sql-translator/pull/51

Wed Apr 08 19:47:59 2015 The RT System itself - Status changed from 'new' to 'open'

Thu Jun 25 09:49:19 2015 ribasushi [...] leporine.io - Correspondence added

I am closing this ticket as "resolved", since there was enough progress made on https://github.com/dbsrgits/sql-translator/pull/51. Please monitor the other ticket if interested in the resolution. Cheers!

Thu Jun 25 09:49:31 2015 ribasushi [...] leporine.io - Status changed from 'open' to 'resolved'