1. 05 Jan, 2014 1 commit
    • José Gabriel González Pérez's avatar
      Fix statement for getTableWhereClause method · 34bfab2c
      José Gabriel González Pérez authored
      If you have a role "postgres" in PostgreSQL that is described like this:
      ```
      -- Role: postgres
      CREATE ROLE postgres LOGIN
        ENCRYPTED PASSWORD 'md53175bce1d3201d16594cebf9d7eb3f9d'
        SUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION;
      ALTER ROLE postgres IN DATABASE sf_test
        SET search_path = "$user", public, access, geographic, rrhh;
      ```
      
      At the time when I execute the statement (Part of $schema value in the line 348):
      ```
      SELECT string_to_array((select replace(replace(setting,"$user",user),' ','') from pg_catalog.pg_settings where name = 'search_path'),',')
      ```
      I fetch this result:
      ```
      {public," access"," geographic"," rrhh"}
      ```
      Look the space character that is on the start of each string.This error does not match any namespace to which the role has access. This is critical when you have PostgreSQL database and you work with schemas.
      34bfab2c
  2. 29 Dec, 2013 1 commit
  3. 01 May, 2013 3 commits
  4. 20 Apr, 2013 1 commit
  5. 14 Apr, 2013 1 commit
  6. 14 Mar, 2013 1 commit
  7. 20 Jan, 2013 1 commit
  8. 25 Nov, 2012 2 commits
  9. 13 Nov, 2012 1 commit
  10. 12 Nov, 2012 2 commits
  11. 16 Oct, 2012 1 commit
  12. 06 Oct, 2012 1 commit
  13. 05 Oct, 2012 1 commit
  14. 17 Sep, 2012 1 commit
  15. 05 Sep, 2012 1 commit
  16. 29 Aug, 2012 1 commit
  17. 14 Aug, 2012 2 commits
  18. 29 Jul, 2012 1 commit
  19. 16 Jul, 2012 1 commit
  20. 08 Jul, 2012 1 commit
  21. 05 Jul, 2012 1 commit
  22. 27 Jun, 2012 1 commit
  23. 26 Jun, 2012 2 commits
  24. 07 Jun, 2012 4 commits
  25. 06 Jun, 2012 1 commit
  26. 27 May, 2012 2 commits
  27. 25 May, 2012 1 commit
  28. 22 May, 2012 1 commit
  29. 18 May, 2012 1 commit
  30. 05 May, 2012 1 commit