[Nitro] Inheritance/Constraints Bug

Emmanuel Piperakis epiperak at softlab.ece.ntua.gr
Thu Dec 22 01:49:48 EST 2005


Dear friends,
I am not sure but I am afraid this is a bug.
class Project
   has_many :loans, Loan
   schema_inheritance
end

class ForeignProject < Project
   property :koko, String
end

class DomesticProject < Project
   property :haha, String
end

class Loan
   belongs_to :project, Project
end

  Og.setup(
    :store => :psql,
    :destroy => true,
    :create_schema => true,
    :evolve_schema => true,
    :evolve_schema_cautious => false,
    :name => 'glycerin',
    :user => 'www-weez',
    :password => '****'
  )

And I get the following error:
(which from what I understand Og is trying to make a constraint with a 
foreign key of ForeignProject, the moment that due to the 
schema_inheritance there is no such oid). Also without schema_inheritance 
same error....

G!!!??? Help!


D, [2005-12-22T14:24:56.437131 #21978] DEBUG -- : PostgreSQL processing 
foreign key constraints
E, [2005-12-22T14:24:56.449050 #21978] ERROR -- : PostgreSQL connection 
returned an error for query ALTER TABLE ogloan ADD CONSTRAINT 
ogc_ogloan_foreign_project_oid FOREIGN KEY (foreign_project_oid) 
REFERENCES ogproject(oid) ON UPDATE SET NULL ON DELETE SET NULL
E, [2005-12-22T14:24:56.449262 #21978] ERROR -- : Og.setup had problems: 
RuntimeError => ERROR  C42703  Mcolumn "foreign_project_oid" referenced in 
foreign key constraint does not exist      Ftablecmds.c    L4054 
RtransformColumnNameList

==> Setup for debug mode
==> Listening at 0.0.0.0:4001.
==> Press Ctrl-C to shutdown; Run with --help for options.


Emmanouil Piperakis (epiperak at cs.ntua.gr)
{To explore is Human, to Create is Devine,
  To teach is Primal, to Rule is Sin}



More information about the Nitro-general mailing list