search for: pg_attribut

...ne | default now() mtime | timestamp without 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....

...tomer_admin"=>{"firstnames"=>"", "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...

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

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

...send emails, then successfully upload another 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/a...

...tiverecord-2.3.2/lib/active_record/connection_adapters/abstract_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...

...om postgres-pr about some wild left-join SQL 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...

...ementInvalid in ''Product The Product model When a 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_...

...ot;159", "controller"=>"match"} Match Load (0.001001) SELECT * FROM matches WHERE (matches.id = ''159'') LIMIT 1 SQL (0.000319) BEGIN PK 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 = co...

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

Can someone explain why Rails is querying the Postgres database every time I retrieve a session variable?? The query is to determine the attributes of the model object I guess and looks like this: "SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT....". Like I said, this SELECT only occurs when I load a variable such as: @value = session[:value] The behaviour seems wrong since it wasn''t occurring using MySQL previously. Thanks, Tyler -- Posted via http://www.ruby-forum.com/.

...for "players" => nil >> Here''s what RoR sends to the postgresql server with this last method call LOG: statement: 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 = '...

...tp://test.local.lo/users/oauth/accounts/callback", "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 Req...

...ot;=>"stores"} Province Load (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://l...

...ery time that I call an action in my controller, every model that is stored in the session needs to be interpreted by a database query? If I have four models stored in the session, I end up with five long "SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull FROM pg_attribute a LEFT JOIN pg_attrdef d....." queries when *ANY* action is called. I''ve tried adding the models in my ApplicationController, but to no avail. It is extremely annoying to sort through the console messages with these repeating queries. Is this supposed to be happening???? Why d...

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

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:

...Call params.[] instead of @params.[]. Args: > ["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: > [&quo...

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.