Hi Guys, I'm completely stumped with this one! I've included ActiveRecord::Base.set_sequence_name in my environment.rb, and in my user.rb I've placed the following code:
class Usertbl < ActiveRecord::Base set_primary_key "user_id" set_sequence_name "seq_user_mytable" validates_uniqueness_of :userpassword, :username, :scope => :user_id end
From http://localhost:3000/usertbl/new I then attempt to enter a new a
record and receive the following error message: RuntimeError: ERROR C23502 Mnull value in column "user_id" violates not-null constraint FexecMain.c L1795 RExecConstraints: INSERT INTO usertbl Oh my head hurts!! -- Regards Andrew On 01/03/07, Andrew Madu < [EMAIL PROTECTED]> wrote:
Hi Dave, my apologies for contacting you off list but i'm having a spot of bother with postgreSQL sequence setup in rails. In addition to what is mentioned below, I have place the following line of code in my environment.rbdocument: # Include your application configuration below ActiveRecord::Base.pluralize_table_names = false ActiveRecord::Base.set_sequence_name What I am overlooking here? -- Regards Andrew ---------- Forwarded message ---------- From: Andrew Madu < [EMAIL PROTECTED]> Date: 01-Mar-2007 15:28 Subject: Re: PostgreSQL primary (sequence) key issue To: [EMAIL PROTECTED] Hi, I've followed the example given here: http://ar.rubyonrails.com/classes/ActiveRecord/Base.html#M000367 and implemented set_sequence_name "seq_name" in my class. When I try to update the user table with a new row from: http://localhost:3000/usertbl/new I get the following error message: RuntimeError: ERROR C23502 Mnull value in column "user_id" violates not-null constraint FexecMain.c L1795 RExecConstraints: INSERT INTO usertbl What am I overlooking here? Also coud possibly give me any clues on how to setup an 'assigned' primary key in an ActiveRecord class? -- Regards Andrew On 01/03/07, Andrew Madu <[EMAIL PROTECTED]> wrote: > > Hi, > I have a sequence set up on one of my tables called seq_user_mytable. I > tried the following with no joy: > > set_primary_key "user_id", :sequence => "seq_user_mytable" and: > > ActiveRecord:: Base.seq_user_mytable > > again with no joy. How do I implement a sequence in Rails/ActiveRecord? > > -- > Regards > > Andrew >
