{"action":"created","issue":{"url":"https://api.github.com/repos/begriffs/postgrest/issues/321","labels_url":"https://api.github.com/repos/begriffs/postgrest/issues/321/labels{/name}","comments_url":"https://api.github.com/repos/begriffs/postgrest/issues/321/comments","events_url":"https://api.github.com/repos/begriffs/postgrest/issues/321/events","html_url":"https://github.com/begriffs/postgrest/issues/321","id":111841600,"number":321,"title":"building from source - \"function unnest(smallint[], smallint[]) does not exist\" ","user":{"login":"mrsot","id":15157508,"avatar_url":"https://avatars.githubusercontent.com/u/15157508?v=3","gravatar_id":"","url":"https://api.github.com/users/mrsot","html_url":"https://github.com/mrsot","followers_url":"https://api.github.com/users/mrsot/followers","following_url":"https://api.github.com/users/mrsot/following{/other_user}","gists_url":"https://api.github.com/users/mrsot/gists{/gist_id}","starred_url":"https://api.github.com/users/mrsot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrsot/subscriptions","organizations_url":"https://api.github.com/users/mrsot/orgs","repos_url":"https://api.github.com/users/mrsot/repos","events_url":"https://api.github.com/users/mrsot/events{/privacy}","received_events_url":"https://api.github.com/users/mrsot/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2015-10-16T14:18:10Z","updated_at":"2015-10-16T14:58:52Z","closed_at":null,"body":"Hello! I am new with postgrest and I need some help with getting the API running. \r\n\r\nI have [built the project from source](https://github.com/begriffs/postgrest/wiki/Building-from-source) on Centos 6.7.\r\n\r\nWhen trying to invoke postgrest it fails and I get the following output:\r\n```\r\n#postgrest --db-host localhost --db-port 5432 --db-name my_db --db-user my_user --db-pass my_pass --db-pool 200 --port 3000 --anonymous my_user\r\nWARNING, running in insecure mode, auth will be in plaintext\r\nWARNING, running in insecure mode, JWT secret is the default value\r\nListening on port 3000\r\npostgrest: user error (TxError (ErroneousResult \"42883\" \"function unnest(smallint[], smallint[]) does not exist\" Nothing (Just \"No function matches the given name and argument types. You might need to add explicit type casts.\")))\r\n#\r\n```\r\n\r\nMy current OS state is:\r\nCentOS release 6.7 (Final)\r\nPostgreSQL 9.3.10\r\ngit version 2.6.1\r\npostgrest-0.2.11.1\r\n\r\nI add the installation output after the \"stack build\":\r\n```\r\n# stack build\r\npostgrest-0.2.11.1: unregistering (local file changes)\r\npostgrest-0.2.11.1: configure\r\nConfiguring postgrest-0.2.11.1...\r\npostgrest-0.2.11.1: build\r\nPreprocessing library postgrest-0.2.11.1...\r\n[ 1 of 12] Compiling PostgREST.Error  ( src/PostgREST/Error.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/Error.o )\r\n[ 2 of 12] Compiling Paths_postgrest  ( .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/autogen/Paths_postgrest.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/Paths_postgrest.o )\r\n[ 3 of 12] Compiling PostgREST.Types  ( src/PostgREST/Types.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/Types.o )\r\n[ 4 of 12] Compiling PostgREST.RangeQuery ( src/PostgREST/RangeQuery.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/RangeQuery.o )\r\n[ 5 of 12] Compiling PostgREST.PgQuery ( src/PostgREST/PgQuery.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/PgQuery.o )\r\n[ 6 of 12] Compiling PostgREST.PgStructure ( src/PostgREST/PgStructure.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/PgStructure.o )\r\n[ 7 of 12] Compiling PostgREST.QueryBuilder ( src/PostgREST/QueryBuilder.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/QueryBuilder.o )\r\n[ 8 of 12] Compiling PostgREST.Parsers ( src/PostgREST/Parsers.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/Parsers.o )\r\n\r\nsrc/PostgREST/Parsers.hs:8:1: Warning:\r\n    The import of βData.Functorβ is redundant\r\n      except perhaps to import instances from βData.Functorβ\r\n    To import instances alone, use: import Data.Functor()\r\n\r\nsrc/PostgREST/Parsers.hs:9:1: Warning:\r\n    The import of βData.Traversableβ is redundant\r\n      except perhaps to import instances from βData.Traversableβ\r\n    To import instances alone, use: import Data.Traversable()\r\n[ 9 of 12] Compiling PostgREST.Config ( src/PostgREST/Config.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/Config.o )\r\n[10 of 12] Compiling PostgREST.Auth   ( src/PostgREST/Auth.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/Auth.o )\r\n[11 of 12] Compiling PostgREST.App    ( src/PostgREST/App.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/App.o )\r\n[12 of 12] Compiling PostgREST.Middleware ( src/PostgREST/Middleware.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/PostgREST/Middleware.o )\r\nIn-place registering postgrest-0.2.11.1...\r\nPreprocessing executable 'postgrest' for postgrest-0.2.11.1...\r\n[ 1 of 13] Compiling Paths_postgrest  ( .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/autogen/Paths_postgrest.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/Paths_postgrest.o )\r\n[ 2 of 13] Compiling PostgREST.Config ( src/PostgREST/Config.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/Config.o )\r\n[ 3 of 13] Compiling PostgREST.Error  ( src/PostgREST/Error.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/Error.o )\r\n[ 4 of 13] Compiling PostgREST.Types  ( src/PostgREST/Types.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/Types.o )\r\n[ 5 of 13] Compiling PostgREST.Parsers ( src/PostgREST/Parsers.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/Parsers.o )\r\n[ 6 of 13] Compiling PostgREST.RangeQuery ( src/PostgREST/RangeQuery.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/RangeQuery.o )\r\n[ 7 of 13] Compiling PostgREST.PgQuery ( src/PostgREST/PgQuery.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/PgQuery.o )\r\n[ 8 of 13] Compiling PostgREST.QueryBuilder ( src/PostgREST/QueryBuilder.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/QueryBuilder.o )\r\n[ 9 of 13] Compiling PostgREST.Auth   ( src/PostgREST/Auth.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/Auth.o )\r\n[10 of 13] Compiling PostgREST.PgStructure ( src/PostgREST/PgStructure.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/PgStructure.o )\r\n[11 of 13] Compiling PostgREST.App    ( src/PostgREST/App.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/App.o )\r\n[12 of 13] Compiling PostgREST.Middleware ( src/PostgREST/Middleware.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/PostgREST/Middleware.o )\r\n[13 of 13] Compiling Main             ( src/PostgREST/Main.hs, .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest-tmp/Main.o )\r\nLinking .stack-work/dist/x86_64-linux-gmp4/Cabal-1.22.4.0/build/postgrest/postgrest ...\r\nWarning: modules not listed in postgrest.cabal for 'postgrest' component (add to other-modules):\r\n    Paths_postgrest\r\n    PostgREST.App\r\n    PostgREST.Auth\r\n    PostgREST.Config\r\n    PostgREST.Error\r\n    PostgREST.Middleware\r\n    PostgREST.Parsers\r\n    PostgREST.PgQuery\r\n    PostgREST.PgStructure\r\n    PostgREST.QueryBuilder\r\n    PostgREST.RangeQuery\r\n    PostgREST.Types\r\npostgrest-0.2.11.1: install\r\nInstalling library in\r\n/usr/local/postgrest/.stack-work/install/x86_64-linux-gmp4/lts-3.7/7.10.2/lib/x86_64-linux-ghc-7.10.2/postgrest-0.2.11.1-1gw55jyuvQAEs2EioXsBin\r\nInstalling executable(s) in\r\n/usr/local/postgrest/.stack-work/install/x86_64-linux-gmp4/lts-3.7/7.10.2/bin\r\nRegistering postgrest-0.2.11.1...\r\n#\r\n```\r\n\r\nCan you please help me find what is wrong with my installation? \r\n\r\nI have also downloaded the latest binary(postgrest-0.2.11.1) and it runs with no issues but I wanted to try the filtering options which are not available yet.\r\n\r\nBest regards!"},"comment":{"url":"https://api.github.com/repos/begriffs/postgrest/issues/comments/148739634","html_url":"https://github.com/begriffs/postgrest/issues/321#issuecomment-148739634","issue_url":"https://api.github.com/repos/begriffs/postgrest/issues/321","id":148739634,"user":{"login":"ruslantalpa","id":5537246,"avatar_url":"https://avatars.githubusercontent.com/u/5537246?v=3","gravatar_id":"","url":"https://api.github.com/users/ruslantalpa","html_url":"https://github.com/ruslantalpa","followers_url":"https://api.github.com/users/ruslantalpa/followers","following_url":"https://api.github.com/users/ruslantalpa/following{/other_user}","gists_url":"https://api.github.com/users/ruslantalpa/gists{/gist_id}","starred_url":"https://api.github.com/users/ruslantalpa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ruslantalpa/subscriptions","organizations_url":"https://api.github.com/users/ruslantalpa/orgs","repos_url":"https://api.github.com/users/ruslantalpa/repos","events_url":"https://api.github.com/users/ruslantalpa/events{/privacy}","received_events_url":"https://api.github.com/users/ruslantalpa/received_events","type":"User","site_admin":false},"created_at":"2015-10-16T14:58:52Z","updated_at":"2015-10-16T14:58:52Z","body":"Not necesarily, we'll try to change the query if possible to be compatible with 9.3"}}