Displaying 16 results from an estimated 16 matches for "adsrc".
Did you mean:
addrc
2006 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
...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.016000) BEGIN
[4;36;1mPK and serial sequence...
2006 Apr 19
0
My database model''s connection appears messed up.
...uot;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 (0.000000) [0;1mBEGIN
[4;35;1mCustomerAdmin...
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
...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/projects/ecera/vendor/rails/activerecord/lib/acti...
2009 Nov 26
2
[error] avahi_entry_group_add_service_strlst("AdminNodeFQDN") failed: Invalid host name
...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.attisdropped
ORDER BY a.attnum
fr...
2006 Apr 29
4
Wild SQL -- public/500.html -- postgres-pr
...s 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 the wild sql comes from ? If I stop everything a...
2008 Nov 04
9
RSpec and PostgreSQL not playing nicely together
...roduct_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.attisdropped
ORDER BY a.attnum
./p...
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
2006 Mar 01
1
Strange Postgres Behaviour with Session Variables
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/.
2010 Sep 17
0
ruby's oauth2 grant_type
...ect_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
Oauth error: invalid grant_type
Rendered text templa...
2006 Feb 12
1
fcgid -> errors
...[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 NOT a.attisdropped
ORDER BY a.attnum
Completed...
2006 Mar 02
3
What am I missing?? Activerecord & Sessions!!
...eone 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 messages with these
repeating queries. Is this sup...
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
...}
> @params is deprecated! 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.[] ins...
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