Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Trying to do some full text searching with postgres and when running the following command

UPDATE "EMAIL" SET PostText = to_tsvector('pg_catalog.english', "TEXT");

I'm getting the error:

ERROR:  text search configuration name "english" must be schema-qualified

Is there something I'm missing? I've also tried

UPDATE "EMAIL" SET PostText = to_tsvector('english', "TEXT");

Edit 1: Table EMAIL has the column "TEXT" in it. They are both in all caps FWIW

share|improve this question

closed as off-topic by dezso, Paul White, StanleyJohns, Mark Storey-Smith, Michael - sqlbot Aug 20 '13 at 1:33

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – dezso, Paul White, StanleyJohns, Mark Storey-Smith, Michael - sqlbot
If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 2 down vote accepted

Double quotes are for case sensitive identifiers or one's that have whitespace in them. Single quotes are for strings.

Try this:

UPDATE "EMAIL" SET PostText = to_tsvector('english', 'TEXT');

You can also remove the quotes around "EMAIL" for a case insensitive match on the field name as well:

UPDATE email SET PostText = to_tsvector('english', 'TEXT');
share|improve this answer
    
UPDATE "EMAIL" SET PostText = to_tsvector('english', TEXT'); gives me same error: ERROR: text search configuration name "english" must be schema-qualified – PSU_Kardi Aug 16 '13 at 18:04
1  
deleted triggers and used your update and it worked. Don't know why but won't a rgue it – PSU_Kardi Aug 16 '13 at 19:17
    
If you deleted triggers and it worked, then perhaps the triggers' code had some error? – ypercubeᵀᴹ Aug 19 '13 at 11:16

Not the answer you're looking for? Browse other questions tagged or ask your own question.