Displaying 17 results from an estimated 17 matches for "atttypmod".
Did you mean:
atttypid
2006 Apr 19
0
My database model''s connection appears messed up.
...r"=>"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;1mCus...
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
...ssfully 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/projects/ecera/vendor/rails/activerecor...
2009 Nov 26
2
[error] avahi_entry_group_add_service_strlst("AdminNodeFQDN") failed: Invalid host name
...iled: 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.attisdropped
ORDER BY a.attnum...
2006 Apr 29
4
Wild SQL -- public/500.html -- postgres-pr
...ostgresql 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 the wild sql comes from ? If I stop ev...
2008 Nov 04
9
RSpec and PostgreSQL not playing nicely together
...pec:
--
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.attisdropped
ORDER BY a....
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 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
...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.016000) BEGIN
[4;36;1mPK and serial...
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.co...
2010 Sep 17
0
ruby's oauth2 grant_type
...;,
"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
Oauth error: invalid grant_type
Rendered t...
2006 Feb 12
1
fcgid -> errors
...2-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 NOT a.attisdropped
ORDER BY a.attnum...
2006 Mar 02
3
What am I missing?? Activerecord & Sessions!!
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 messages with these
repeating queries. I...
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
...uot;user"}
> @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 par...
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