similar to: [PATCH] fix postgresql_adapter index dumping with multiple schemas

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

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

Not getting any love (tender or otherwise) on my pull request<https://github.com/rails/rails/pull/7035>so I thought you folks might like to chip in. What do you think? #cast and #cast! allow you to declare a mapping from generated column names to simplified database column types (i.e. those used in migrations). This way scopes with columns generated in their select lists can also include

I would like to set some db session variables specific to my application on the database connection that rails uses. They can be set by issuing an SQL command like "SET statement_timeout = 1000" once - it will be in effect for every subsequent SQL statement that uses this connection. So I tried to put the following into an initializer: ActiveRecord::Base.connection.execute("SET

I have a problem when i am creating a rails project using postgresql... uninitialized constant ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::PGconn I have already installed gem postgres-pr. but not start.. I using rails version 2.3.5 Ruby 1.8.7 PostgresSQL 1.10.2. Please help me thanks. -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to

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

There''s some confusion as to what the :limit option should mean when used against integer columns in migrations. Patch #2900 added support for limits in PostgreSQL mapping mapping limit < 4 to smallint, > 4 to bigint, and anything else to integer (so the limit is the number of bytes) However, the mysql adapter uses limit to specify the ''display width'' in digits,

Hello, I use a software that outputs the data in a form/dialect(?) of xml (I think its called "SpreadsheetML", see below for an excerpt). It allows (admittedly) easy import of such files into Excel. I would like, however, to import it directly into R. I am familiar how to do that with standard xml-files (mostly thanks to Duncan Temple Lang's help). But I haven't found the right

Dear r-sig Debian list, I subscribe to the 'r-help' forum but as requested on the "Download and Install" section of CRAN I am reporting a suspected bug on the " bin/linux/ubuntu dapper/" installation binaries, I show an extract from my Ubuntu(dapper) terminal console below---- # Attempted unsuccessful installation copy from terminal-- root at ubup:/etc/apt# sudo

CentOS Errata and Bugfix Advisory 2018:1980 Upstream details at : https://access.redhat.com/errata/RHBA-2018:1980 The following updated files have been uploaded and are currently syncing to the mirrors: ( sha256sum Filename ) x86_64: c1476708492df529be4c61e8cd19ad001028504df5f9d02d057bdbc80b25c2c4 gsettings-desktop-schemas-3.24.1-2.el7_5.i686.rpm

Hi I have a problem accessing an array field in a Postgresql database. Here is the table definition. View "neil.flashing_codes" Column | Type | Modifiers -------------+-----------------------+----------- code | character varying(10) | description | text | folds | integer[] | View definition: SELECT

OS: Redhat 9.0 Kernel: 2.4.20-8 Asterisk: latest CVS head Hi all, I try to compile the latest chan_capi, but it won't work. I also tried the patch that is arround there from frank sautter and I have installed the asterisk header files. Asterisk is working very good :) and the Fritz AVM pc Card is running. capiinit: 1 fcpci running fritz-pci A1 3.11-02 0xbc00 5 lsmod: fcpci

Hello, My questions are meant to be not necessarily specific...I am looking for advice and best practices for setting up an R environment. Here's my situation: I am one of perhaps three or four individuals who will be analyzing the same data through the use of R. I would like to set up a "base" environment for our project, basically some scripts that connect to a database, load

Played around with rails on mysql a little bit. Now I''m looking at rails on postgres, and postgres has schemas. Wondering if it''s appropriate to create *schemas* for my three db evironments (development, test, production) rather than separate dbs? b

hello all! i am about to deploy an app that needs to connect to different schemas... uhm. let me explain. the app is located on a server (of course), and on the same server is a database with many schemas called new_york, cicago, barcelona, hongkong, singapore and so on. people from this citys need to use the app, and the app should connect to the correct schema depending from where they

Hey folks, ** Description ** Firstly for those who don''t know, Ferret is a full-text search library which makes adding search to your application a breeze. It''s much faster than MySQL full-text search as well most other search libraries out there. It allows you to do Boolean (+ruby + rails -jewelry) and phrase queries ("the quick brown fox") as well as some more

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

Hey folks, Since this is the Ferret mailing list I should preface this by that the donation of time and help by people like Jens Kraemer, Jan Prill and all the other people who have contributed to Ferret is just as valuable to me as any financial assistance. Thanks. Ferret has been a labour of love but it has taken up a lot more of my life than I ever expected. At in excess of 50,000 lines of