Take the 2-minute tour ×
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.

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.

add comment

1 Answer

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
    
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
add comment

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