search for: attnam

...roup | text | itime | timestamp without time zone | 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....

...anguage R version.string R version 2.15.2 (2012-10-26) nickname Trick or Treat I'm trying to use RWeka, in particular an example in the help file for make_Weka_classifier > model <- NB(Class ~ ., data = HouseVotes84) Error in .jnew("weka/core/Attribute", attname[i], .jcast(levels, "java/util/List")) : java.lang.NoSuchMethodError: <init> > traceback() 8: stop(list(message = "java.lang.NoSuchMethodError: <init>", call = .jnew("weka/core/Attribute", attname[i], .jcast(levels, "java/util/List")...

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.

...stomer_admin", "controller"=>"login", "customer_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...

...lgName <- "LinearRegression" Formula <- as.formula(paste(as.name(att), " ~ ", paste(otherAtts, collapse= "+"))) myAlg <- get(algName) cl <- myAlg(Formula, data = Data) And this is the error I'm getting: Error in .jnew("weka/core/Attribute", attname[i]) : java.lang.NoSuchMethodError: <init> Here is the printout of the a working case: cl = Linear Regression Model petallength = 1.748 * sepallength + -1.4174 * sepalwidth + -2.1294 ClusterData[j,] = sepallength sepalwidth petallength petalwidth cl...

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

...the background. Note: I can successfully upload a csv, then fail trying to 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/p...

...trlst("AdminNodeFQDN") failed: Invalid host name /usr/lib/ruby/gems/1.8/gems/activerecord-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.attisdr...

Every page of my DEPOT on Postgresql rails app now gets an error from 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 t...

...the error message when I run this spec: -- spec product_spec.rb F 1) ActiveRecord::StatementInvalid 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...

...ction"=>"comment", "id"=>"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.refobj...

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

...t;- evaluate_Weka_classifier(m, cost = matrix(c(0,2,1,0), ncol = 2), numFolds = 10, complexity = TRUE, seed = 123, class = TRUE) e summary(e) e$details ============ But executing "J48(play~., data = w)" generates the following error: ====== Error in .jnew("weka/core/Attribute", attname[i], .jcast(levels, "java/util/List")) : java.lang.NoSuchMethodError: <init> ====== Can anybody help me to fix this problem? Thanks!

...r.connection.default_sequence_name "players" => "players_id_seq" >> Player.connection.pk_and_sequence_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...

...bcd3ea936be1148443d9df2f7cf363", "redirect_uri"=>"http://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 Oaut...

...ler#search (for 10.0.0.60 at 2006-02-12 12:24:02) [GET] Parameters: {"action"=>"search", "controller"=>"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...

Can someone please explain why every 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 mes...

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