First time here? Check out the FAQ!

Revision history  [back]

How to fix search when switching from MySQL to Postgresql?

Hi, I ran the SQL script for the search on Postgres, but I still get errors about missing columns on some table.

column askbot_thread.text_search_vector does not exist
LINE 1: ...estion'  AND "askbot_post"."deleted" = false  AND askbot_thr...

I read somewhere here that you guys run Postgres 8.4, but that's pretty old. Can you please figure out why it doesn't work on 9.1+?

Thanks!

How to fix Can the search when switching from MySQL to Postgresql?be fixed for Postgres 9.1?

Hi, I ran the SQL script for the search on Postgres, but I still get errors about missing columns on some table.

column askbot_thread.text_search_vector does not exist
LINE 1: ...estion'  AND "askbot_post"."deleted" = false  AND askbot_thr...

I read somewhere here that you guys run Postgres 8.4, but that's pretty old. Can you please figure out why it doesn't work on 9.1+?

Thanks!

Can the search be fixed for Postgres 9.1?

Hi, I ran the SQL script for the search on Postgres, but I still get errors about missing columns on some table.

column askbot_thread.text_search_vector does not exist
LINE 1: ...estion'  AND "askbot_post"."deleted" = false  AND askbot_thr...

I read somewhere here that you guys run Postgres 8.4, but that's pretty old. Can you please figure out why it doesn't work on 9.1+?

Thanks!