Displaying 9 results from an estimated 9 matches for "currval".
Did you mean:
curval
2006 Mar 16
3
inserted_at seems buggy in production mode?
...h_comments''::regclass
MatchComment Create (0.002280) INSERT INTO match_comments ("body",
"match_id", "player_id", "inserted_at") VALUES(''testtest'', 159, 14,
''2006-03-16 12:22:55'')
SQL (0.000684) SELECT currval(''public.match_comments_id_seq'')
SQL (0.034973) COMMIT
Redirected to http://tcuithof.laddertennis.nl/match/show/159
Processing MatchController#comment (for 192.87.30.169 at 2006-03-16
12:24:57) [POST]
Parameters: {"mc"=>{"body"=>"test"...
2006 Jul 20
4
Help with Rails and postgres with sequence numbers (global?)
...schema and still I want to use Rails to access it and not pure SQL.
When I try to insert a record I get the following message:
ActiveRecord::StatementInvalid: RuntimeError: ERROR C42P01
Mrelation "parts
group_id_seq" does not exist Fnamespace.c L200
RRangeVarGetRelid: SELEC
T currval(''partsgroup_id_seq'')
This is of course true, because of the global sequence.I did look into
the postgres_adapter and found pk_and_sequence_for but I am only
understanding nada. ;-)
schema:
lxtest=# \d partsgroup
Table "public.partsgroup"...
2008 Apr 06
1
Scrambling objects ID's for users
...estimate
my database size by simple reading ids. Whats the solution? Is somewhere
a rails plugin (i use rails 2.0.2)? I have problem with standard
approach - by simple replacing id column by string and generate guid in
callbacks - i use a postgresql database and my rails app raises some
error with currval. Any solution? thanks
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5T...
2006 Sep 01
2
Mrelation does not exists
Hello!
I''m having the following error:
RuntimeError: ERROR C42P01 Mrelation "subjects_users_id_seq" does not
exist Fnamespace.c L200 RRangeVarGetRelid: SELECT currval
(''subjects_users_id_seq'')
when I try to do:
subject= SubjectsUser.new(params[:subjects_user])
subject.save
The models:
class User < ActiveRecord::Base
has_one :last_entrie
has_one :address_book
has_and_belongs_to_many :subjects
has_one :user_detail
has_and_belongs_to_...
2006 Apr 15
8
Migrations - adding a new table and automatically creating records
I want to create table called roles and then populate it with some new
records...This doesn''t work. Is there something I''m missing?
Craig
class AddRightsAndRolesTables < ActiveRecord::Migration
def self.up
create_table :roles do |t|
t.column "name", :string
end
Role.reset_column_information
Role.new :name => "Users Admin"
2005 Jul 07
0
Migration: server with smb 2.2 -> new server, 2.2 too, weird issues
...stem\CurrentControlSet\Control\Lsa\EveryoneIncludesAnonymous SUCCESS 0x0
lsass.exe:568 CloseKey HKLM\System\CurrentControlSet\Control\Lsa SUCCESS
lsass.exe:568 OpenKey HKLM\SECURITY\Policy\Secrets\$MACHINE.ACC SUCCESS Access: 0x2001F
lsass.exe:568 OpenKey HKLM\SECURITY\Policy\Secrets\$MACHINE.ACC\CurrVal SUCCESS Access: 0x20019
lsass.exe:568 QueryValue HKLM\SECURITY\Policy\Secrets\$MACHINE.ACC\CurrVal\(Default) BUFFER OVERFLOW
lsass.exe:568 CloseKey HKLM\SECURITY\Policy\Secrets\$MACHINE.ACC\CurrVal SUCCESS
lsass.exe:568 OpenKey HKLM\SECURITY\Policy\Secrets\$MACHINE.ACC\CurrVal SUCCESS Access: 0x...
2006 Jun 11
0
postgres fixtures and sequence id field
Hi
I''ve a problem testing my application.
Basicly when tests try to load the fixture in my postgresql database I
obtain the error
currval of sequence "my sequence name" is not yet defined in this session
The problem is the ID field: basicly the fixtures try to add
explicitly a defined ID but postgres don''t like this, even if I build
a brand new DB and try to push the id 1.
How can I make the fixtures load smoothl...
2006 May 12
0
Using primary key that is not named "id"
...n I used >ruby script/generate scaffold Product Admin
to generate my controllers. When I try to insert a new product in the
products table, it gave me this error
RuntimeError: ERROR C42P01 Mrelation "product_productid_seq" does not
exist Fnamespace.c L195 RRangeVarGetRelid: SELECT
currval(''Product_ProductID_seq'')
What does this mean and is what can I do to solve this?
Thank you!
--
Posted via http://www.ruby-forum.com/.
2006 Mar 29
0
active record bug?
..., ''d gdssg sd5
gd5g '', NULL, ''2006-03-29 11:13:42'', ''2006-03-29 11:13:42'', NULL, NULL,
''/irx/xml/DGdssgSd5Gd5g.xml'', ''dgbtev sgdg d'', ''DGdssgSd5Gd5g'', NULL,
NULL)
SQL (0.000440) SELECT currval(''inforx.topics_id_seq'')
# output of a logger.info statement spitting out the id of the newly
inserted topic
HERE IS THE TOPIC ID: 3126
# i explicitly select the topic:
Topic Load (0.000649) SELECT * FROM topics WHERE (topics.id = 3126)
LIMIT 1
# and print out a logger statem...