Displaying 16 results from an estimated 16 matches for "attisdrop".
2006 Apr 19
0
My database model''s connection appears messed up.
...}}
[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'') LIMIT 1
[4;36;1mSQL (0.010000) [0;1mCOMMIT
Redirected to http://localhost:3000/login/add_customer_a...
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
...o 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/rails/activerecord/lib/active_record/
connection_adapters/postgresql_adapter.rb:142:in `query''
/usr/...
2009 Nov 26
2
[error] avahi_entry_group_add_service_strlst("AdminNodeFQDN") failed: Invalid host name
....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'
from
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/postgresql_adapter.rb:...
2006 Apr 29
4
Wild SQL -- public/500.html -- postgres-pr
...stgresPR::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 xpsp2, ruby 1.8.4, rails 1.1.2, postgres-pr (0.4.0)
-------------- next part --------------...
2008 Nov 04
9
RSpec and PostgreSQL not playing nicely together
..., 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 understand why RSpec is trying to look for some kind of
relation. In the spec I am simply calling Product.new
This spec worked perfe...
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?)
...[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,
pg_depend dep,
pg_namespace name,
pg_constraint cons
WHERE seq.oid = dep.objid
AND seq.relnamespac...
2010 Sep 17
0
ruby's oauth2 grant_type
...ot;}
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
Started GET "/users/oauth/accounts/callback?
code=d264c2496d0dc5c494b7269f2f9e4c30cd55a571b6944d3231f63577acd12b1b&am...
2006 Feb 12
1
fcgid -> errors
...mat_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 on Sun Feb 12 12:24:01 CET 2006 by logger.rb/1.5.2.4
[12/Feb/2006:12:24:01 :: 4133] starting
[12/Feb...
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
...L (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/../app/controllers/user_controller.rb:8)
> @params is deprecated! Call params.[] instead of @params.[]. A...
2006 May 18
5
Overriding default DELETE behavior with logical deletes
Hello!
I am trying to figure out how to implement *logical deletes* instead of
physical deletes using ActiveRecord. Basically, in many applications
that deal with E-Commerce, you really can''t physically delete almost
anything, because records must be kept for auditing and customer service
tracking purposes.
In the past, I''ve implemented logical deletes as follows:
1.
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