search for: attrelid

...ithout time zone | Triggers: mtime_partsgroup BEFORE UPDATE ON partsgroup FOR EACH ROW EXECUTE PROCEDURE set_mtime() and log file: [4;36;1mSQL (0.047000) [0;1m SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = ''partsgroup''::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum [4;35;1mSQL (0.016000) BEGIN [4;36;1mPK and serial sequence (0.031000) [0;1m SELECT attr.attname, name.nspname, seq.relname FROM...

...;=>"", "adminlogin"=>"zzzzz", "surname"=>"", "password"=>""}} [4;35;1mSQL (0.010000) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = ''customer_admins''::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum [4;36;1mSQL (0.000000) [0;1mBEGIN [4;35;1mCustomerAdmin Load (0.000000) SELECT * FROM customer_admins WHERE (customer_admins.a...

Hi, I get errors doing this: 1) createdb myapp_test 2) rake db:test:clone_structure 3) rake test:units rake aborted! PGError: ERROR: relation "matches" already exists I''m using the :sql schema format because there are some problems with postgres and the :ruby schema format config.active_record.schema_format = :sql It seems rake test:units is trying to create the tables

...other csv file. Also, sending emails works in production when used outside of backgroundrb. backgroundrb_debug.log reports this PGError: no connection to the server : SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = ''sandboxed_libraries''::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''...

...act_adapter.rb:212:in `log': PGError: ERROR: relation "pools" does not exist (ActiveRecord::StatementInvalid) : SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d 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_ada...

...that has nothing to do with my tables: SQL (0.000000) NameError: undefined local variable or method `errors'' for #<PostgresPR::Connection:0x3b200c0>: SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = ''line_items''::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum Any idea where the wild sql comes from ? If I stop everything and swap out the database.yml so it points to the msysql database, and res...

...new blank product object gets created should not be valid'' PGError: ERROR: relation "products" does not exist : SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = ''products''::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum ./product_spec.rb:7:in `new'' ./product_spec.rb:7: Finished in 1.025511 seconds 1 example, 1 f...

...K and serial sequence (0.017476) SELECT attr.attname, name.nspname, seq.relname FROM pg_class seq, pg_attribute attr, pg_depend dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = ''S'' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = ''p'' AND dep.refobjid = ''match_comments''::regclass MatchComment Create (0.002280) INSERT INTO match_comments (&qu...

1) I get Rails Application Error when trying to use layout test_controller def list layout "stdlayout" end in the views/test/layouts stdlayout.rhtml <html> <head><title>test</title></head> </body> <h1>Test</h1> <%= content_for_layout %> </body> </html> 2) I get Rails Application Error when trying to use a separate

...dep, pg_namespace name, pg_constraint cons WHERE seq.oid = dep.objid AND seq.relnamespace = name.oid AND seq.relkind = ''S'' AND attr.attrelid = dep.refobjid AND attr.attnum = dep.refobjsubid AND attr.attrelid = cons.conrelid AND attr.attnum = cons.conkey[1] AND cons.contype = ''p'' AND dep.refo...

...back", "type"=>"web_server", "code"=>"d264c2496d0dc5c494b7269f2f9e4c30cd55a571b6944d3231f63577acd12b1b"} SQL (0.8ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = ''"oauth_clients"''::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum Oauth error: invalid grant_type Rendered text template (0.0ms) Completed 400 Bad Request in 112ms (Views: 37.9ms | ActiveReco...

...(0.009293) SELECT * FROM provinces Rendering within layouts/stores Rendering stores/search SQL (0.021030) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnullince Load (0.009293)ESC[0m ESC[0;1mSELECT * FROM provinces FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attrelid = ''provinces''::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum Completed in 0.17092 (5 reqs/sec) | Rendering: 0.06057 (35%) | DB: 0.03032 (17%) | 200 OK [http://linuxsi/stores/search] fastcgi seems less...

Hello, I''m working with a postgresql table CREATE TABLE elements ( id serial primary key, c1 text default f1(), ... cN text default fN() ); But if I use de lines @element = Element.new @element.save the values that element take are the nextval in the id field and nules in all the other fields. How can I get the defaults? (but without rewriting the

Hi, I have the following view: <%= start_form_tag ( { :action => ''find'' }, :method => ''get'') %> <p> <%= text_field_tag :lemma, params[:lemma] %> </p> <%= link_to "Find It", :class => "submit" %> <%= end_form_tag %> And the following find action in the controller:

...["user"] (login at > > /pt/webprops/sysadmin/tst/public/../config/../app/controllers/user_controller.rb:7) > [4;36;1mSQL (0.002785) [0;1m SELECT a.attname, format_type( > a.atttypid, a.atttypmod), d.adsrc, a.attnotnull > FROM pg_attribute a LEFT JOIN pg_attrdef d > ON a.attrelid = d.adrelid AND a.attnum = d.adnum > WHERE a.attrelid = ''users''::regclass > AND a.attnum > 0 AND NOT a.attisdropped > ORDER BY a.attnum > > @params is deprecated! Call params.[] instead of @params.[]. Args: > ["user"] (login at > > /pt/webprop...

Hi, I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the RPostgreSQL package for interfacing with a postgresql database. I am using postgresql 8.3.7. A query that works from the postgresql terminal is causing a segfault when executed from R. My sessionInfo, the error message, and the R code used to generate the error are listed below. I have noticed that a

I have 2 models, entity and client. Entity has_one client and client belongs_to entity. Entity has attributes name and legal_name. Entity also has an unique index on (lower(name)). The pKey for both is the conventional Rails id. Client has a fKey constraint on entity_id and is indexed in entity_id. In controllers/clients_controller.rb I have: # GET /clients/new # GET /clients/new.xml

Hi, I read the example in http://wiki.rubyonrails.com/rails/pages/HowtoUseMultipleDatabases, it show us how to connect to other database, each time we start a new action, however, this doesn''t work while you try to connect to two different database within the same action. SO I wonder is it possible to bind to two or more database within the same action???? Thanks you very much Saiho

Hello! I am trying to figure out how to implement *logical deletes* instead of physical deletes using ActiveRecord. Basically, in many applications that deal with E-Commerce, you really can''t physically delete almost anything, because records must be kept for auditing and customer service tracking purposes. In the past, I''ve implemented logical deletes as follows: 1.