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