Rails postgres structure.sql remove schema name

Question

I've pulled down a Rails repo (# ruby '2.5.0', gem 'rails', '~> 5.1', gem 'pg', '~>1.0', & psql 9.6.8) When running rake db:structure:dump the structure.sql is modified and the schema name gets added to the table create statements. Other than that the structure is unmodified. How do I remove them to stop collisions with the existing project.

CREATE TABLE public.account_roles (

When it was previously

SET search_path = public, pg_catalog;
...
CREATE TABLE account_roles (

The SET search_path also gets removed. I tried setting schema_search_path: 'public,pg_catelog' in database.yml configuration. This has no effect. What configuration was set to dump the sql structure without the schema?

Yep, ran into this too but I think this question has you covered — Anthony
– Anthony, Commented Apr 20, 2018 at 0:28
Possible duplicate of rails g migrate with postgres prefixes commands with schema name — Anthony
– Anthony, Commented Apr 20, 2018 at 0:28
@Anthony yip it appears to be related to the postgres version. I can't find another explanation — Lex
– Lex, Commented Apr 23, 2018 at 1:30

Lex · Accepted Answer · 2018-06-13 04:12:32Z

1

The issue was caused by a newer version of Postgres being installed on my local.

We confirmed the issue by having another dev with the same project update their postgres version.

Knowing that we committed the new version into the repo and had everyone upgrade. And are working on dockerizing the project so things like psql version will remain consistent.

answered Jun 13, 2018 at 4:12

Lex

5,0944 gold badges48 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Rails postgres structure.sql remove schema name

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related