Displaying 16 results from an estimated 16 matches for "pg_attrdef".
2006 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
...| 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 (0.031000) [0;1m SELECT
attr.attname, name.nspname, s...
2006 Apr 19
0
My database model''s connection appears messed up.
...uot;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 Load (0.000000) SELECT * FROM customer_admins
WHERE (...
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
...essfully 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/active_record/
connection_adapters/abstract_adapter.rb:128:i...
2009 Nov 26
2
[error] avahi_entry_group_add_service_strlst("AdminNodeFQDN") failed: Invalid host name
...ve_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
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/c...
2006 Apr 29
4
Wild SQL -- public/500.html -- postgres-pr
...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 and swap out the
database.yml so it points to the msysql...
2008 Nov 04
9
RSpec and PostgreSQL not playing nicely together
...;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
./product_spec.rb:7:in `new''
./product_spec.rb:7:
Finished in...
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
...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 template (0.0ms)
Completed 400 Bad Request in 112ms (Views: 37...
2006 Feb 12
1
fcgid -> errors
...;}
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 in 0.17092 (5 reqs/sec) | Rendering: 0.06057 (35%) | DB:
0.03032 (17%) | 200 OK [http://linuxsi/stores/search]
f...
2006 Mar 02
3
What am I missing?? Activerecord & Sessions!!
...ction 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 supposed to be happening???? Why do normal
ActiveRecord o...
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
...@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.[] instead of @params.[]. Args:
> ["user"] (login at...
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