search for: schema_search_path

Hi guys, I need your help. Here is my database.yml: development: adapter: postgresql database: db username: username password: mypassword # Connect on a TCP socket. Omitted by default since the client uses a # domain socket that doesn''t need configuration. Windows does not have # domain sockets, so uncomment these lines. host: 192.168.22.1 (this is a remote ip in

I am building an app that every company has it own private schema(Postgresql). For every requisition, I set the Postgres search path in a before_action like this: ActiveRecord::Base.connection.schema_search_path = 'company_id, public' If I have multiple Unicorn workers, and one worker 'A' set the path, while another work 'B' set the path before worker A has finish, I think it will generate some conflict and 'A' worker could accidently save/read models from the wrong sche...

Hi guys. I''m using a postgreSQL with multiple schemas. To change between schemas I use the ''SET schema TO ...'' statement. That works ok in rails 3.0. Rails 3.1 uses prepared statements and does not take into account the ''schema_search_path''. This is a big problem because the statement is prepared once and then the same prepared statement is executed many times no matter if you changed the schema, i.e, the prepared statement is executed ALWAYS for the same schema, the one set when the statement was prepared. I migrated yeste...

...ng on different versions of db. So I decided to make following structure that seems much prettier for me megaproject_db - public schema (db info) - test schema - development schema - production schema Does anybody tried to make the same thing that I want to do? I found in wiki that I need to add schema_search_path to db config file. So first question: why so strange name for schema property?? I have looked through code and found that this property contains a list of schema name. And table names are looking for thought all this schemas. I am wonder, is anybody need it (i mean multiply schemas)? Well, after...

...o me. My database is called bookkeeping and has several tables, one of which is called ''address''. I''ve changed the .yml file to have the following: development: adapter: postgresql database: bookkeeping_dev username: toby password: whatever host: localhost schema_search_path: public test: adapter: postgresql database: bookkeeping_test username: toby password: whatever host: localhost schema_search_path: public production: adapter: postgresql database: bookkeeping username: toby password: whatever host: localhost schema_search_path: public I...

...Connect on a TCP socket. Omitted by default since the client uses a # domain socket that doesn''t need configuration. Windows does not have # domain sockets, so uncomment these lines. #host: localhost #port: 5432 # Schema search path. The server defaults to $user,public #schema_search_path: myapp,sharedapp,public # Minimum log levels, in increasing order: # debug5, debug4, debug3, debug2, debug1, # log, notice, warning, error, fatal, and panic # The server defaults to notice. #min_messages: warning # Warning: The database defined as "test" will be eras...

In Postgres, I use different database schemas for each application, by declaring, e.g.: class ApplicationController < ActionController::Base ActiveRecord::Base.table_name_prefix = "keywords." end I assumed that the sequence names were also prefixed with the database schema names, e.g. keywords.things_id_seq But Rails 1.2.3 assumes the sequence is *NOT* in the same schema as the

Hello, I have tried to install the salted hash login generator by following the quick start guide at: http://wiki.rubyonrails.com/rails/pages/SaltedLoginGeneratorQuickstart. Everything seems to work fine until I try to run the unit tests by doing ''rake test_units'', then I get the following error message: <error-message> [brasse@keso login-test]$ rake test_units (in

...tabase: expenses_development username: expenses password: # Connect on a TCP socket. Omitted by default since the client uses a # domain socket that doesn''t need configuration. #host: remote-database #port: 5432 # Schema search path. The server defaults to $user,public #schema_search_path: myapp,sharedapp,public # Character set encoding. The server defaults to sql_ascii. #encoding: UTF8 # Minimum log levels, in increasing order: # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, log, fatal, or panic # The server defaults to notice. #min_me...

...ils.foo.com_development username: rails.foo.com password: # Connect on a TCP socket. Omitted by default since the client uses a # domain socket that doesn''t need configuration. #host: remote-database #port: 5432 # Schema search path. The server defaults to $user,public #schema_search_path: myapp,sharedapp,public # Character set encoding. The server defaults to sql_ascii. #encoding: UTF8 # Minimum log levels, in increasing order: # debug5, debug4, debug3, debug2, debug1, # info, notice, warning, error, log, fatal, or panic # The server defaults to notice. #min_me...