search for: postgresql_adapt

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

...ings_count\" + 1 WHERE (\"id\" = 2) AND ( (\"posts\".\"type\" = ''SpecialPost'' ) ) "> ---Backtrace--- ./test/../lib/active_record/connection_adapters/abstract_adapter.rb:156:in `log'' ./test/../lib/active_record/connection_adapters/postgresql_adapter.rb:407:in `execute_without_counting'' ./test/abstract_unit.rb:71:in `execute'' ./test/../lib/active_record/connection_adapters/abstract/database_statements.rb:162:in `update_sql'' ./test/../lib/active_record/connection_adapters/postgresql_adapter.rb:418:in `update_sql'...

...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 resolves: /.../jenkins/.rvm/gems/ruby-1.9.3-p194@my_application/gems/activerecord-3.2.9/lib/active_record/connection_adapters/postgresql_adapter.rb:652:in `async_exec'': PG::Error: ERROR: permission denied: "RI_ConstraintTrigger_1234" is a system trigger (ActiveRecord::StatementInvalid) : (SQL here) from /.../jenkins/.rvm/gems/ruby-1.9.3-p194@my_application/gems/activerecord-3.2.9/lib/active_record/connection_adap...

...;::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum /usr/local/projects/ecera/vendor/rails/activerecord/lib/active_record/ connection_adapters/abstract_adapter.rb:128:in `log'' /usr/local/projects/ecera/vendor/rails/activerecord/lib/active_record/ connection_adapters/postgresql_adapter.rb:142:in `query'' /usr/local/projects/ecera/vendor/rails/activerecord/lib/active_record/ connection_adapters/postgresql_adapter.rb:528:in `column_definitions'' /usr/local/projects/ecera/vendor/rails/activerecord/lib/active_record/ connection_adapters/postgresql_adapter.rb:223:i...

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,

...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'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/postgresql_adapter.rb:713:in `connect'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/ connection_adapters/postgresql_adapter.rb:237:in `initialize'...

...ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = 'pools'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/postgresql_adapter.rb:494:in `query' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1039:in `column_definitions' from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/postgresql_adapter...

...ion denied Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? RAILS_ROOT: /var/www/html/blog/public/../config/.. Application Trace | Framework Trace | Full Trace /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in `connect'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:23:in `postgresql_connection'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract/connection_specification.rb...

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

...;postgres''. I have done the following: > > > > ''gem install postgres'' > > > > I now have both postgres-0.7.1 and postgres-pr-0.4.0 sitting in > > C:\pgRails\lib\ruby\gems\1.8\gems > > > > What do I need to alter in my database.yml/postgresql_adapter.rb > > documents so that I can access the postgres driver? > > > > -- > > Regards > > > > Andrew > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on R...

.../lib/ruby/gems/1.8/gems/postgres-pr-0.6.1/lib/postgres-pr/postgres-compat.rb:23:in `new'' /usr/lib/ruby/gems/1.8/gems/postgres-pr-0.6.1/lib/postgres-pr/postgres-compat.rb:23:in `initialize'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:968:in `connect'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:968:in `connect'' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/postgresql_adapter.rb:217:in `initialize...

...r while processing the request. : SELECT * FROM works ORDER BY added desc LIMIT 10 /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:137:in `execute'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:351:in `select'' /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:118:in `select_all'&...

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 convert the string back to array, it is very time consuming job...

..._name order by created_at desc ...<snip>... c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log'' c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:137:in `execute'' c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapter.rb:351:in `select'' c:/development/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/postgresql_adapte...

...moves the connection, but its doesn''t unbind the link between rails and the database. So we decide to add some new methodes in order to remove all link between rails and the database. First, we added a new methode to the adapter, we are using postgresql, the following code is written for postgresql_adapter.rb if you are using another database, you have to rewrite it. In postgresql_adapter.rb, add the follong code def disconnect if (@connection != nil) then # methode "close" is exported by the postgres.so for disconnect the database @connection.close @connection = nil # cle...

...you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message. rake aborted! FATAL: database "catarse_development" does not exist /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `initialize' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `new' /usr/local/rvm/gems/ruby-1.9.3-p484/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql_adapter.rb:831:in `conne...

...ter 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 yesterday from 3.0 to 3.1 and ended up with all my new data (INSERT operations) into the same schema. ''exec_cache'' method in postgresql_adapter.rb uses the sql string as the cache key. Maybe we could include also the ''schema_search_path''. I didn''t want to go into details here, but I could create an issue or a pull request if this approach seems reasonably. Juan -- You received this message because you are s...

...due_on < ''2006-07-31 13:40:17'')) from C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log'' from C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/connection_adapters/postgresql_adapter.rb:148:in `execute'' from C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/connection_adapters/postgresql_adapter.rb:361:in `select'' from C:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/connection_adapters/postgresql_adapte...

...> ^ > : CREATE INDEX "index_sf_events_on_account_id" ON "sf_events"( > )/home/ben/.rvm/gems/ruby-1.9.3-p392-railsexpress@workbench-api/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:650:in > `async_exec'' > /home/ben/.rvm/gems/ruby-1.9.3-p392-railsexpress@workbench-api/gems/activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:650:in > `block in execute'' > /home/ben/.rvm/gems/ruby-1.9.3-p392-railsexpress@workbench-a...

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