# Problems generating scaffolding **URL:** \ **Category:** ruby-talk\ **Created:** [7 February 2007 21:34 UTC](https://rubytalk.org/t/problems-generating-scaffolding/35164 "2007-02-07T21:34:28Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Glen\_Holcomb](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Glen\_Holcomb](https://rubytalk.org/u/Glen_Holcomb)\ **Post date:** [7 February 2007 21:34 UTC](https://rubytalk.org/t/problems-generating-scaffolding/35164/1 "2007-02-07T21:34:28Z")
Hello, I'm trying to write a rails application using Postgres for my back-end. When I go to generate the scaffolding some of them work and some of them don't. I'm not sure why some are failing. According to Postgres all the tables exist yet rails only seems to find some of them. Here is the SQL I'm using to generate the tables: CREATE TABLE dept (   name character varying(20) NOT NULL,   CONSTRAINT dept\_pkey PRIMARY KEY (name) ) WITHOUT OIDS; CREATE TABLE computer\_role (   model character varying(15) NOT NULL,   os character varying(10) NOT NULL,   role integer NOT NULL,   CONSTRAINT computer\_role\_pkey PRIMARY KEY (model, os, role) ) WITHOUT OIDS; CREATE TABLE computers (   ram integer NOT NULL,   model character varying(15) NOT NULL,   cpu integer NOT NULL,   cores integer NOT NULL DEFAULT 1,   disk integer NOT NULL, -- Space in Gigabytes   census integer NOT NULL,   CONSTRAINT computers\_pkey PRIMARY KEY (model, ram, disk) ) WITHOUT OIDS; COMMENT ON COLUMN computers.disk IS 'Space in Gigabytes'; CREATE TABLE technicians (   name character varying(40) NOT NULL,   phone character(4) NOT NULL,   department character varying(20) NOT NULL,   email character varying(30) NOT NULL,   CONSTRAINT technician\_pkey PRIMARY KEY (email) ) WITHOUT OIDS; CREATE TABLE sites (   room character varying(8) NOT NULL,   num\_machines integer NOT NULL,   dept character varying(20) NOT NULL,   software character varying(25)[] NOT NULL,   machine\_types integer[] NOT NULL,   machine\_type character varying(20)[] NOT NULL,   CONSTRAINT sites\_pkey PRIMARY KEY (room),   CONSTRAINT sites\_dept\_fkey FOREIGN KEY (dept)       REFERENCES dept (name) MATCH SIMPLE       ON UPDATE RESTRICT ON DELETE NO ACTION ) WITHOUT OIDS; CREATE TABLE free (   name character varying(15) NOT NULL,   publisher character varying(15),   version character varying(8) NOT NULL,   num\_copies integer NOT NULL,   depts character varying(15)[] NOT NULL,   CONSTRAINT free\_pkey PRIMARY KEY (name, version) ) WITHOUT OIDS; CREATE TABLE licensed (   name character varying(30) NOT NULL,   version character varying(10) NOT NULL,   publisher character varying(15) NOT NULL,   serial character varying(25) NOT NULL,   lm boolean NOT NULL,   license\_file text,   licenses integer NOT NULL,   num\_disks smallint NOT NULL DEFAULT 1,   CONSTRAINT licensed\_pkey PRIMARY KEY (name, version, publisher) ) WITHOUT OIDS; It has no trouble with sites, computers or technicians but doesn't like the others at all. Any help would be appreciated. > **···** > > -- > "Hey brother christian with your high and mighty errand, Your actions speak > so loud, I can't hear a word you're saying." > > -Greg Graffin (Bad Religion) ---
**Author:** ![Glen\_Holcomb](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Glen\_Holcomb](https://rubytalk.org/u/Glen_Holcomb)\ **Post date:** [7 February 2007 21:36 UTC](https://rubytalk.org/t/problems-generating-scaffolding/35164/2 "2007-02-07T21:36:03Z")
Sorry I forgot the error I'm getting Before updating scaffolding from new DB schema, try creating a table for your model > **···** > > On 2/7/07, Glen Holcomb \ wrote: > > > Hello, > > > > I'm trying to write a rails application using Postgres for my back-end. > > When I go to generate the scaffolding some of them work and some of them > > don't. I'm not sure why some are failing. According to Postgres all the > > tables exist yet rails only seems to find some of them. > > > > Here is the SQL I'm using to generate the tables: > > > > CREATE TABLE dept > > ( > >   name character varying(20) NOT NULL, > >   CONSTRAINT dept\_pkey PRIMARY KEY (name) > > ) > > WITHOUT OIDS; > > > > CREATE TABLE computer\_role > > ( > >   model character varying(15) NOT NULL, > >   os character varying(10) NOT NULL, > >   role integer NOT NULL, > >   CONSTRAINT computer\_role\_pkey PRIMARY KEY (model, os, role) > > ) > > WITHOUT OIDS; > > > > CREATE TABLE computers > > ( > >   ram integer NOT NULL, > >   model character varying(15) NOT NULL, > >   cpu integer NOT NULL, > >   cores integer NOT NULL DEFAULT 1, > >   disk integer NOT NULL, -- Space in Gigabytes > >   census integer NOT NULL, > >   CONSTRAINT computers\_pkey PRIMARY KEY (model, ram, disk) > > ) > > WITHOUT OIDS; > > COMMENT ON COLUMN computers.disk IS 'Space in Gigabytes'; > > > > CREATE TABLE technicians > > ( > >   name character varying(40) NOT NULL, > >   phone character(4) NOT NULL, > >   department character varying(20) NOT NULL, > >   email character varying(30) NOT NULL, > >   CONSTRAINT technician\_pkey PRIMARY KEY (email) > > ) > > WITHOUT OIDS; > > > > CREATE TABLE sites > > ( > >   room character varying(8) NOT NULL, > >   num\_machines integer NOT NULL, > >   dept character varying(20) NOT NULL, > >   software character varying(25) NOT NULL, > >   machine\_types integer NOT NULL, > >   machine\_type character varying(20) NOT NULL, > >   CONSTRAINT sites\_pkey PRIMARY KEY (room), > >   CONSTRAINT sites\_dept\_fkey FOREIGN KEY (dept) > >       REFERENCES dept (name) MATCH SIMPLE > >       ON UPDATE RESTRICT ON DELETE NO ACTION > > ) > > WITHOUT OIDS; > > > > CREATE TABLE free > > ( > >   name character varying(15) NOT NULL, > >   publisher character varying(15), > >   version character varying(8) NOT NULL, > >   num\_copies integer NOT NULL, > >   depts character varying(15) NOT NULL, > >   CONSTRAINT free\_pkey PRIMARY KEY (name, version) > > ) > > WITHOUT OIDS; > > > > CREATE TABLE licensed > > ( > >   name character varying(30) NOT NULL, > >   version character varying(10) NOT NULL, > >   publisher character varying(15) NOT NULL, > >   serial character varying(25) NOT NULL, > >   lm boolean NOT NULL, > >   license\_file text, > >   licenses integer NOT NULL, > >   num\_disks smallint NOT NULL DEFAULT 1, > >   CONSTRAINT licensed\_pkey PRIMARY KEY (name, version, publisher) > > ) > > WITHOUT OIDS; > > > > It has no trouble with sites, computers or technicians but doesn't like > > the others at all. > > > > Any help would be appreciated. > > > > -- > > "Hey brother christian with your high and mighty errand, Your actions > > speak so loud, I can't hear a word you're saying." > > > > -Greg Graffin (Bad Religion) > > -- > "Hey brother christian with your high and mighty errand, Your actions speak > so loud, I can't hear a word you're saying." > > -Greg Graffin (Bad Religion) ---
**Author:** ![Patrick\_Hurley1](https://avatars.discourse-cdn.com/v4/letter/p/b77776/32.png) [@Patrick\_Hurley1](https://rubytalk.org/u/Patrick_Hurley1)\ **Post date:** [7 February 2007 21:47 UTC](https://rubytalk.org/t/problems-generating-scaffolding/35164/3 "2007-02-07T21:47:20Z")
Not trying to be rude, but rails specific questions are best handled on Rails specific forums (see [http://rubyonrails.org/community\](http://rubyonrails.org/community%5C)) or you may want to try a local user group where the message volume is not so high. Good luck pth > **···** > > On 2/7/07, Glen Holcomb \ wrote: > > > \> I'm trying to write a rails application using Postgres for my back-end. ---
**Author:** ![Glen\_Holcomb](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Glen\_Holcomb](https://rubytalk.org/u/Glen_Holcomb)\ **Post date:** [7 February 2007 21:51 UTC](https://rubytalk.org/t/problems-generating-scaffolding/35164/4 "2007-02-07T21:51:01Z")
Sorry not really thinking right now. Will ask there. > **···** > > On 2/7/07, Patrick Hurley \ wrote: > > > On 2/7/07, Glen Holcomb \ wrote: > > \> \> I'm trying to write a rails application using Postgres for my > > back-end. > > > > Not trying to be rude, but rails specific questions are best handled > > on Rails specific forums (see [http://rubyonrails.org/community\](http://rubyonrails.org/community%5C)) or you > > may want to try a local user group where the message volume is not so > > high. > > > > Good luck > > pth > > -- > "Hey brother christian with your high and mighty errand, Your actions speak > so loud, I can't hear a word you're saying." > > -Greg Graffin (Bad Religion)