API tools faq
paste
Guest User

Untitled

a guest
May 23rd, 2018
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.53 KB | None | 0 0
raw download clone embed print report
  1. mbp:wisardgroup davidhund$ ./manage.sh sqltsearch2 | psql wisardgroup_orgap
  2. BEGIN
  3. UPDATE 14
  4. NOTICE: index "orgap_organizationname_fts_idx" does not exist, skipping
  5. DROP INDEX
  6. CREATE INDEX
  7. CREATE FUNCTION
  8. NOTICE: trigger "on_orgap_organizationname_fts_update_or_insert" for table "orgap_organizationname" does not exist, skipping
  9. DROP TRIGGER
  10. CREATE TRIGGER
  11. UPDATE 5
  12. NOTICE: index "orgap_description_full_text_index_idx" does not exist, skipping
  13. DROP INDEX
  14. CREATE INDEX
  15. CREATE FUNCTION
  16. NOTICE: trigger "on_orgap_description_full_text_index_update_or_insert" for table "orgap_description" does not exist, skipping
  17. DROP TRIGGER
  18. CREATE TRIGGER
  19. ERROR: column "country" does not exist
  20. LINE 1: ...ess SET fts=to_tsvector('english', city || ' ' || country );
  21. ^
  22. ERROR: current transaction is aborted, commands ignored until end of transaction block
  23. ERROR: current transaction is aborted, commands ignored until end of transaction block
  24. ERROR: current transaction is aborted, commands ignored until end of transaction block
  25. ERROR: current transaction is aborted, commands ignored until end of transaction block
  26. ERROR: current transaction is aborted, commands ignored until end of transaction block
  27. ROLLBACK
  28. mbp:wisardgroup davidhund$ ./manage.sh sqltsearch2 | psql wisardgroup_orgap
  29. BEGIN
  30. UPDATE 14
  31. NOTICE: index "orgap_organizationname_fts_idx" does not exist, skipping
  32. DROP INDEX
  33. CREATE INDEX
  34. CREATE FUNCTION
  35. NOTICE: trigger "on_orgap_organizationname_fts_update_or_insert" for table "orgap_organizationname" does not exist, skipping
  36. DROP TRIGGER
  37. CREATE TRIGGER
  38. UPDATE 5
  39. NOTICE: index "orgap_description_full_text_index_idx" does not exist, skipping
  40. DROP INDEX
  41. CREATE INDEX
  42. CREATE FUNCTION
  43. NOTICE: trigger "on_orgap_description_full_text_index_update_or_insert" for table "orgap_description" does not exist, skipping
  44. DROP TRIGGER
  45. CREATE TRIGGER
  46. ERROR: column "country" does not exist
  47. LINE 1: ...ess SET fts=to_tsvector('english', city || ' ' || country );
  48. ^
  49. ERROR: current transaction is aborted, commands ignored until end of transaction block
  50. ERROR: current transaction is aborted, commands ignored until end of transaction block
  51. ERROR: current transaction is aborted, commands ignored until end of transaction block
  52. ERROR: current transaction is aborted, commands ignored until end of transaction block
  53. ERROR: current transaction is aborted, commands ignored until end of transaction block
  54. ROLLBACK
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!