1. S

    PG gem won't install in Rails app: Gem::Ext::BuildError: ERROR: Failed to build gem native extension

    I'm trying to deploy my Rails app to Heroku and when I add the pg gem to my gemfile and run bundle install I get an error: An error occurred while installing pg (1.1.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.1.3'` succeeds before bundling. The bottom of my gemfile...
  2. P

    KnexJS raw query in migration

    I have a problem with the following migration in KnexJS, working with PostgreSQL: exports.up = (knex) => { knex.raw('CREATE EXTENSION IF NOT EXISTS "uuid-ossp"'); return knex.schema.createTable('car_brands', (table) => {...
  3. D

    Multiple insert in parametrized statement with PG gem

    Using the Ruby PG gem, I am trying to insert several rows at the same time with exec_params. What I would like to acheive is: INSERT INTO public.my_things (col1, col2) VALUES ('value11', 'value12'), ('value21', 'value22'), ('value31', 'value32'); I tried this (and other...
  4. X

    'psql' is not recognized as an internal or external command

    I have installed postgresql 10 on my windows 10 and added those paths but when i go to the CMD under administration rights and test PSQL or psql --version ... i still get the same error 'psql' is not recognized as an internal or external command i tried echo %path% and i can see the path...