similar to: I have problem ....PostgreSQLAdapter::PGconn

Hi, We have experienced some problems with ActiveRecord::Base class of Ruby-Rails. We are building a web-application based on the Ruby-rails framework and the web-application needs to access to difference databases, so we do not pre-define our database accesses in the database.yml file. In fact, we are using the ActiveRecord::Base.establish_connection() to connect to our database, the function

Hi, I''m trying to write a new postgresql adapter which interited the old postgres adapter and I try to use the PGconn class, But I find out I can''t access to some of the exported functions in postgres.so (I''m using LINUX) In fact, only the methode export with rb_define_singleton_method can be used, only function s exported with rb_define_method, the PGconn ruby class

Hi, I really need help to understand what is happening while Rails connect to a database, (we area actually using postgresql, so my example will be with postgresql) What I understand is Rails is able to connect to different DB. Actually, this is what we want, and we have made some tests, everything is juste fine. However, all these tests lead us to some important questions that we did find the

The build failed. CHANGES ------- Revision 8649 committed by gbuesing on 2008-01-16 20:07:10 Introducing DateTime #utc, #utc? and #utc_offset, for duck-typing compatibility with Time. Closes #10002 M /trunk/activesupport/CHANGELOG M /trunk/activesupport/lib/active_support/core_ext/date_time/calculations.rb M /trunk/activesupport/test/core_ext/date_time_ext_test.rb TEST FAILURES AND

Hi, Ruby 1.8.4 Rails 1.1.4 Windows XP Pro I''m hitting an issue with migrations that I suspect relates to pluralization. Here''s the migration: class Hardware < ActiveRecord::Migration def self.up create_table :hardware do |h| h.column :vendor, :string, :limit => 32 h.column :model, :string, :limit => 32 end

I''ve installed the postgres-pr gem, and it is found using gem list v0.4.0. In my active record source, inside the postgresql_adapter.rb file, I''ve changed line 7 from: require_library_or_gem ''postgres'' unless self.class.const_defined?(:PGconn) to: require_library_or_gem ''postgres-pr'' unless self.class.const_defined?(:PGconn) ...to try and

I still want to get this into Rails for all connection adaptors, but for now I''ve hacked my own addition on for just PostgreSQL. The following code extends every Column object returned by MyModel.columns to support a new #required? method, which indicates if the column may or may not be null. The following is a huge hack - suggestions on a cleaner way to add this functionality

I have tried small ruby program like require ''rubygems'' require ''postgres'' db = PGconn.connect(''localhost'', 5432, '''', '''', ''prdjnj'',''postgres'', ''postgres'') res=db.exec("select * from users limit 300000") res.clear puts "After clear result

I recently submitted a pull-request (https://github.com/rails/rails/pull/10939) to address a bug in PostgreSQLAdapter#disable_referential_integrity related to how the existing code behaves in a transaction when the PostgreSQL user account lacks superuser privileges on the PostgreSQL instance. While this permits the code to function without crashing, it doesn''t actually make

Is there some special magic that needs to be performed so that the C-based postgres extension library works with the Rails console? I have installed the postgres extension library (replacing the pure Ruby version: postgres-pr) from <http://ruby.scripting.ca/postgres/> Everything works great from WEBrick, but as soon as I fire up the console and try to use it, I get a bus error:

I want to set default value to current time of database: class CreateUsers < ActiveRecord::Migration def self.up create_table :users do |t| # ... t.column :created_at, :timestamp, :null => false, :default => ''now'' end end #... end On postgresql, it is converted to: created_at timestamp NOT NULL DEFAULT ''2006-04-25

I forgot to take out the portion that would read in the voicemail boxes from the text file. If you want to leave it in then you could have some voicemail boxes defined in the text voicemail.conf. I do not, so I have removed it. Below is the new patch: *** app_voicemail.c 2004-06-23 07:55:54.000000000 -0600 --- app_voicemail.c.new 2004-06-23 07:55:47.000000000 -0600 *************** *** 49,61 ****

Hello all, I am just getting going on building my system, but I thought I'd send you all a patch that I wrote so the command: show voicemail users issued from the CLI works properly when there is a postgres backend for the voicemail. The current version of the app does not display the voicemail boxes found in a database. It is called in the load_config function. I haven't done

Hi List, first of thank you Ezra for BackgroundRB. Very cool plugin indeed! This is a public service FYI. In case you are running postgres as your database backend and you are seeing the following errors in your backgroundrb.log: ActiveRecord::StatementInvalid: NoMethodError: undefined method `async_query'' for #<PGconn:0x22ed648>: You are using the postgres-pr adapter

Hi, I cannot compile Meetme2 on Suse 9.1 and Asterisk rc2. For latter 2 errors I guess I need development for mysql and postgres, but what about first error ? Regards, Robert. In file included from app_meetme2.c:13: /usr/include/asterisk/lock.h: In function `ast_mutex_init': /usr/include/asterisk/lock.h:300: error: `PTHREAD_MUTEX_RECURSIVE' undeclared (first use in this function)

Hello, I successfully dumped the database in postgresql. Now I want to connect my rails application to the postgresql database, able to start the server, but I am getting this error when I browse the application from the browser. script/server => Booting WEBrick => Rails 2.3.5 application starting on http://0.0.0.0:3000 Sphinx cannot be found on your system. You may need to configure the

I need to bootstrap my database when creating schema. My model class and migration class are the same. When I trying: ClassName.create :foo => ''bar'' in migration I got: undefined method `create'' for #<ActiveRecord::ConnectionAdapters::PostgreSQLAdapter:0xb75a357c> How to avoid this? I think the same class names causes problem, but I can''t change

Forgive me for asking a trivial question on this list, but being new to Ruby/Ruby on Rails, I''m not sure where to start.... I''m trying to connect to a postgresql server: My database.yml contains: test_test: adapter: postgresql database: test_test username: testuser password: resutest host: testpgserver port: 5432 encoding: UTF8 min_messages: warning The

First of all, I''d like to do what I''ve seen several others here do: thank Ezra and any other contributors for producing a really great plugin. Even though I''m having some minor problems, this is all so approachable and easy to work with and dig into... I hate to think of the hoops you''d need to jump through (both as creator of such a system and as a user) to

Hi, I installed ovirt on fedora 12 (64 bits) successfully but I had to make some changes to make it work. 1. Installation from rpms builded from the lastest git version 2. Patch ace : missing backslashes in sed commands vim /usr/share/ace/modules/ovirt/manifests/freeipa.pp line 33 : '/\\[kdcdefaults\\]/a \\ kdc_ports = 88' single_exec {"set_kdc_defaults":