Hi, this one has been finally put to bed!! -- Regards
Andrew On 01/03/07, Andrew Madu <[EMAIL PROTECTED]> wrote:
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 > > > >