Also just to follow up, creating the index works fine. i.e. alter_table :test__accounts do add_index :oldindex end
On Friday, July 26, 2013 2:53:47 PM UTC-4, [email protected] wrote: > > Hello, > I'm trying to write some migrations that remove indexes. We currently use > schemas in postgres quite heavily and I think I'm running into a bug with > the drop table qualification. > > I have this as the drop table line: > drop_index :test__accounts, :oldindex > > and when it runs I get this error: > PG::Error: ERROR: index "test_accounts_oldindex_index" does not exist > > But if I go into my database and check I see that I have the index in the > test schema: > select schemaname, tablename, indexname from pg_indexes where indexname = > 'test_accounts_oldindex_index'; > > schemaname | tablename | indexname > ------------+-----------+------------------------------------------ > test | accounts | test_accounts_oldindex_index > > Doing it manually with the generated index name works if I prefix it with > the schema, without it it fails. > > Is this a bug or do I need to do something different to qualify the table > for drop table? > > Thanks, > Erik > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/groups/opt_out.
