similar to: Connecting to existing postgreSQL database in Win32

Displaying 20 results from an estimated 600 matches similar to: "Connecting to existing postgreSQL database in Win32"

2010 Aug 20
0
Problem with db:create
My ruby app always created the databases on postgres just fine, but, a days ago, I''ve tried to create a new project and when I execute the command "db:create:all" i got the following error: Couldn''t create database for {"encoding"=>"unicode", "username"=> "-my username-", "adapter"=>"postgresql",
2011 Sep 13
4
Prepared statements and postgreSQL schemas
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
2014 May 19
0
Can ActiveRecord::Base.connection.schema_search_path be set per process?
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
2005 Dec 14
2
console and webrick problems
Hi, I''m having errors when running webrick or the console. webrik starts, but give me an error when I try to load my controller. It give the same error as the console: #ruby script/console Loading development environment. /usr/lib/ruby/gems/1.8/gems/rails-1.0.0/lib/commands/console.rb:23:in `exec'': No such file or directory - irb -r irb/completion -r
2006 Aug 16
6
Newbie-Question
Hi. I''ve just started using Ruby on Rails. Now I''ve got my first problem. I generated a new migration ''add_price'' and get the message:
2005 Oct 28
3
PostgreSQL. Multiply schemas in one database. How to?
Hi all. I am using PostgreSQL in my current project and I have couple of questions on this topic. Previously I have used 3 databases for project. i.e. megaproject_development, megaproject_test and megaproject_development. But I don''t like this variant because of ''rake dump_db_structure'' writes a lot of PostgreSQL specific data for structure file (operators, functions,
2006 Mar 20
1
RJS & IE Woes
Hi, I''m trying to do a very simple slide_down effect with RJS templates. Basically a user selects a check box and a text box slides down. This works great in firefox, but causes IE to crash. The text box appears and slides down. Then the browser crashes. the in the partial is <div id=''forklift_div''> <label for=''incident_forklift''>Was
2006 Jan 16
2
ActiveRecord: table name with spaces?
Howdy. I''m trying to work with a legacy SQL Server database where some of the table names have spaces in them. I''ve done set_table_name "tablename with spaces", but I can''t get find(:all) to work. I get the following error (because apparently it''s not putting [ ] around the name as is required for SQL Server for names with spaces.
2005 May 19
0
Re: Problem with Rails and OCI8
Here''s a solution to the OCI8 problem shown below (change /usr/local/oracle to your site''s oracle): If this happens when you are running scripts at the shell prompt: export LD_LIBRARY_PATH=/usr/local/oracle/lib If this happens in your apache error_log, add to httpd.conf: SetEnv LD_LIBRARY_PATH /usr/local/oracle/lib Kevin Kleinfelter If it''s not documented,
2006 Mar 30
2
database.yml and Dreamhost
I am unable to connect to my databases. Here is the error I am getting: MysqlError (Can''t connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2)): Here is my database.yml: # MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Get the fast C bindings: # gem install mysql # (on OS X: gem install mysql --
2006 Jul 03
13
Remote Postgres is driving me crazy!
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
2007 Mar 05
6
Using ms access 97 as local db backend for rails on windows 2000
Hi, I am on a windows 2000 machine and want to use an ms access 97 database (*.mdb) as db backend. I did a clean install: ruby, gems, rails, odbc-rails. A test rails application connecting to a local mysql server is doing fine. I can also locally connect to the odbc connection "local_odbc_name" with the aqua data studio client. But now with rails. As soon as I change the adapter to
2006 Mar 31
14
[newbi] Create a Model
Hello All, Yesterday i put RoR with Locomotive. I am very happy :p. So I follow this tuto (http://developer.apple.com/tools/rubyonrails.html). I used Sqlite. my database.yml # MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Get the fast C bindings: # gem install mysql # (on OS X: gem install mysql -- --include=/usr/local/lib) # And be sure to use new-style password
2007 Jun 19
2
sequence name prefix
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
2015 Sep 03
0
mclapply memory leak?
Toby, > On Sep 2, 2015, at 1:12 PM, Toby Hocking <tdhock5 at gmail.com> wrote: > > Dear R-devel, > > I am running mclapply with many iterations over a function that modifies > nothing and makes no copies of anything. It is taking up a lot of memory, > so it seems to me like this is a bug. Should I post this to > bugs.r-project.org? > > A minimal reproducible
2006 Feb 28
10
Salted hash login, postgresql, unit tests
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
2013 Feb 16
0
[LLVMdev] MCJIT and Lazy Compilation
Hey Sean, I'm sure Andy.K will have some thoughts on this but I don't imagine any major API changes being required. The changes that I have been making are really very minor, all the work is already done. However I can imagine some client side fallout due to the multi-module nature of the proposed solution. The client side problem being that I imagine that many people are using a single
2006 Apr 03
15
How should I pick a random entry from the database?
Hi guys. Total newbie here. I''ve been doing web stuff since 1996 but only began the foray into scripting last year. I haven''t got my skull completely 360 degrees around OOP yet. It''s just me here (in Japan) and there are no Ruby groups in my area (never mind any in English). I''ve got a database table - real simple: question, answer, and id fields - and I
2013 Jun 05
3
dashboard/passenger not connecting on port 8140
I have setup passenger w/ apache, but my dashboard is not connecting properly. I am getting the following errors em::Specification#installation_path called from /etc/puppet/puppet-dashboard/vendor/rails/railties/lib/rails/vendor_gem_source_index.rb:93. NOTE: Gem::Specification#installation_path is deprecated, use base_dir. It will be removed on or after 2011-10-01.
2007 Jan 22
1
Duplicate Desktop Icons...
Hi, I posted this problem a while back but wasn't able to resolve the issue. It's gotten worse--now almost all of my users in the network have the duplicate icon problem. I'm recently upgraded to samba-3.0.23d from 3.0.21 on an OpenBSD 4.0 server. I'm using folder redirection to redirect the Application Data, Desktop, My Documents, and Favorites folders off to