similar to: Prepared statements and postgreSQL schemas

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,

I have a simple project created around a very, very simple database: one main table packs with just three rows Column | Type | Modifiers --------+-----------------------------+---------------------------------------------------- id | integer | not null default nextval(''packs_id_seq''::regclass) nombre | character

I''ve been runnning Perl under Apache for a while but have decided to try using Ruby-on-Rails. My current database is postgreSQL 8.1. I have no problem connecting to it using Perl or PHP 5. However, I''m obviously missing something ''cos no matter what I do I cannot connect to the database from RoR. I have followed all of the instructions I could find and when I start

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

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Anyone know what''s going on with ActiveRecord Edge and 1.2RC1 unit tests. I get 13 failures from the "async_exec" method call. ie: test_callback_rollback_in_save(ConcurrentTransactionTest): ActiveRecord::StatementInvalid: NoMethodError: undefined method `async_exec'' for #<PGconn:0xb75a8754>: SET

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

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

Buen día a todos, Alguien conoce si existe la manera de determinar cuellos de botella pasados o actuales en poblaciones naturales remanentes con información genética (microsatélites) en R. Gracias por su valiosa ayuda de antemano. Saludos, Diego ________________ Diego P. Vélez Mora Departamento de Ciencias Biológicas UNIVERSIDAD TÉCNICA PARTICULAR DE LOJA San Cayetano Alto s/n Loja, Ecuador

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",

Hi, After doing a clean install of ovirt in a Fedora 11 VM, I am unable to get anything working in the web interface. All I get is an error 500. After reviewing the logs I see the following error in /var/log/http/error.log [Thu Nov 26 11:29:11 2009] [notice] Apache/2.2.13 (Unix) DAV/2 mod_auth_kerb/5.4 mod_nss/2.2.11 NSS/3.12.2.0 mod_python/3.3.1 Python/2.6 configured -- resuming normal

Please review this patch for postgres adapter''s referential_integrity.rb in Rails master and 3.2.9 and let me know what you think. We are using it via an initializer (monkey patching the adapter directly vs. in module): https://github.com/rails/rails/pull/8498 Fixes this issue also seen by others in Foreigner: https://github.com/matthuhiggins/foreigner/issues/61 Problem that it

I have bdrb successfully set up and running in a local project. It''s doing two things: 1) processing large csv files and using ActiveRecord to insert 2) sending large batches of emails using ActionMailer In development both work well. I see my ActionMailer emails in the log (though it''s the development.log -- odd?) On the production server csv processing works well, but

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

My databases.yml makes no mention of root and in my dev environment everything works fine, however following a deployment with Capistrano about an hour ago, I get the following error: PGError in HomeController#index FATAL: role "root" does not exist /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/postgresql_adapter.rb:713:in `connect''

Hi, I''ve recently updated an old patch to PostgreSQLAdapter#indexes, which fixes a bug with schema dumping with multiple database schemas present. The new patch corrects an edge case bug in the original patch, includes test cases, and has been tested against PostgreSQL 7.4, 8.1 and 8.3. The ticket is at http://dev.rubyonrails.org/ticket/8659 ; I''d appreciate any code review,

Hello, I''m a newbie to rails and I am trying to do the Demo in the November Issue of Linux Journal. Things go fine go fine until I try to connect to my Postgres database (ver 8.1). At this point I get the following error message ---- RoR error and trace back ---- PGError in Admin#index could not connect to server: Permission denied Is the server running on host "localhost"

Figured it out chaps..not to worry!!! -- Regards Andrew On 05/03/07, Andrew Madu <andrewmadu-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Hi, > further to my additional email the gem build for postgres did not work, so > I downloaded and copied postgres.so into: > > C:\pgRails\lib\ruby\site_ruby\1.8\i386-msvcrt > > Again, how do I point rails to using this

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

Hello All, If I run my unit tests individually using Ruby, they all work correctly. However, if I try to run them using "rake test_units", I get a bunch of error messages. The error messages appear to be caused by rake not loading any of the fixtures into the test database. I am using PostgreSQL on Windows. Does anyone have any suggestions? Many thanks, Bruce. -- Posted via

Hi We are using postgresql with rails, we find out that when we read array from postresql (postgresql support array type in table) the rails (or postgresql_adapter) converts the arrays into Strings, example: we have a data type array in a table which has two cells: [cell1,cell2], rails will convert them into string like this {cell1,cell2}. So after received the result from a SQL request we have