search for: adnum

Displaying 15 results from an estimated 15 matches for "adnum".

Did you mean: dnum
2006 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
..._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 pg_class seq, pg_attribute attr,...
2006 Apr 19
0
My database model''s connection appears messed up.
...uot;=>"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.adminlogin = ''zzzzz'...
2006 Apr 03
2
problems testing on 1.1 and postgresql
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
2008 Jan 15
1
actionmailer the background
...s 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'' /usr/local/projects/ecera/vendor/r...
2009 Nov 26
2
[error] avahi_entry_group_add_service_strlst("AdminNodeFQDN") failed: Invalid host name
...ror: 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_adapter.rb:494:in `query'...
2006 Apr 29
4
Wild SQL -- public/500.html -- postgres-pr
...: 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 restart, it works fine as before. Win...
2008 Nov 04
9
RSpec and PostgreSQL not playing nicely together
...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 failure -- I don''t underst...
2005 Dec 31
7
Application Errors w/ layout & custom view pages
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
2010 Sep 17
0
ruby's oauth2 grant_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 | ActiveRecord: 178.2ms) and from client Start...
2006 Feb 12
1
fcgid -> errors
...endering 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 healthy though: # Logfile created...
2006 May 03
4
default values
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
2006 Aug 06
6
View passing empty or no value to controller -- help
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:
2006 Aug 25
0
Re: login sugar
...; /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/webprops/sysadmin/tst/public/../config/../...
2006 Jan 19
4
multiple database in the same actions?
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
2008 Mar 08
9
Validation error handling on related models
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