Hi Robert- I can't answer your question, but it looks like a bug. Your schema may in fact be too complicated for Doctrine to reverse engineer it (I have no idea), but at the very least - it should probably throw an exception if it gets into the place (like in your example) where there is an undefined variable.
The undefined variable is caused by some sort of mismatch between a foreign key and a local key, and if none ever match, you get this undefined variable (this all happens around line 196 of DatabaseDriver). This sounds like a Doctrine issue, so I'd try my luck in the Doctrine google group or IRC. Thanks! Ryan Weaver US Office Head & Trainer - KnpLabs - Nashville, TN http://www.knplabs.com <http://www.knplabs.com/en> http://www.thatsquality.com Twitter: @weaverryan On Fri, Apr 29, 2011 at 3:53 PM, Robert Campbell <wapr...@gmail.com> wrote: > This is the ddl for my database. > > CREATE OR REPLACE FUNCTION manage_object() RETURNS trigger > LANGUAGE plpgsql > AS $$ > DECLARE > object_entity_name TEXT; > begin > IF (TG_OP = 'INSERT') THEN > IF NEW.id IS NULL THEN > insert into object (entity_name) values (TG_RELNAME) RETURNING id INTO > NEW.id; > ELSE > select entity_name into object_entity_name from object where id=NEW.id; > IF FOUND THEN > IF EXISTS (select * from information_schema.tables where > table_catalog=CURRENT_CATALOG and table_schema=CURRENT_SCHEMA and > table_name=object_entity_name) THEN > EXECUTE 'select * from ' > || object_entity_name > || ' where id=$1' USING NEW.id; > IF FOUND THEN > RAISE EXCEPTION 'The object id is alreasy assigned to another object.'; > > END If; > ELSE > IF (object_entity_name != TG_RELNAME) THEN > update object set entity_name=TG_RELNAME where id=NEW.id; > END IF; > END IF; > ELSE > insert into object (id, entity_name) values (NEW.id, TG_RELNAME); > END IF; > END IF; > RETURN NEW; > ELSIF (TG_OP = 'UPDATE') THEN > update object set id=NEW.id, entity_name=TG_RELNAME where id=OLD.id; > return NEW; > ELSIF (TG_OP = 'DELETE') THEN > delete from object where id=OLD.id; > return OLD; > END IF; > end; > $$; > > CREATE OR REPLACE FUNCTION manage_actor() RETURNS trigger > LANGUAGE plpgsql > AS $$ > DECLARE > actor_entity_name TEXT; > begin > IF (TG_OP = 'INSERT') THEN > IF NEW.id IS NULL THEN > insert into actor (entity_name) values (TG_RELNAME) RETURNING id INTO > NEW.id; > ELSE > select entity_name into actor_entity_name from actor where id=NEW.id; > IF FOUND THEN > IF EXISTS (select * from information_schema.tables where > table_catalog=CURRENT_CATALOG and table_schema=CURRENT_SCHEMA and > table_name=actor_entity_name) THEN > EXECUTE 'select * from ' > || actor_entity_name > || ' where id=$1' USING NEW.id; > IF FOUND THEN > RAISE EXCEPTION 'The actor id is alreasy assigned to another actor.'; > > END If; > ELSE > IF (actor_entity_name != TG_RELNAME) THEN > update actor set entity_name=TG_RELNAME where id=NEW.id; > END IF; > END IF; > ELSE > insert into actor (id, entity_name) values (NEW.id, TG_RELNAME); > END IF; > END IF; > RETURN NEW; > ELSIF (TG_OP = 'UPDATE') THEN > update actor set id=NEW.id, entity_name=TG_RELNAME where id=OLD.id; > return NEW; > ELSIF (TG_OP = 'DELETE') THEN > delete from actor where id=OLD.id; > return OLD; > END IF; > end; > $$; > > CREATE TABLE module ( > name varchar(100), > title varchar(255) NOT NULL, > description varchar(255) NOT NULL, > status smallint not null, > PRIMARY KEY (name) > ); > > CREATE TABLE object ( > id serial, > entity_name varchar(255) NOT NULL, > PRIMARY KEY (id) > ); > > CREATE TABLE actor ( > id serial, > entity_name varchar(255) NOT NULL, > PRIMARY KEY (id) > ); > > CREATE TABLE email_address ( > email_address varchar(50) NOT NULL, > actor_id integer NOT NULL, > status smallint NOT NULL, > create_time timestamp NOT NULL, > update_time timestamp DEFAULT NULL, > PRIMARY KEY (email_address) > ); > > alter table email_address > add constraint fk_email_address_actor foreign key (actor_id) references > actor(id) on delete cascade on update cascade; > > CREATE TABLE email_address_confirmation ( > email_address varchar(50) NOT NULL, > code varchar(32) NOT NULL, > create_time timestamp NOT NULL, > update_time timestamp DEFAULT NULL, > PRIMARY KEY (email_address) > ); > > alter table email_address_confirmation > add constraint fk_email_address_confirmation_email_address foreign key > (email_address) references email_address(email_address) on delete cascade on > update cascade; > > CREATE TABLE person ( > id integer not null, > email_address varchar(50) NOT NULL, > username varchar(32) DEFAULT NULL, > password varchar(32) NOT NULL, > status smallint NOT NULL, > create_ip varchar(39) NOT NULL, > create_time timestamp NOT NULL, > update_time timestamp DEFAULT NULL, > UNIQUE (email_address), > UNIQUE (username), > PRIMARY KEY (id) > ); > > alter table person > add constraint fk_actor foreign key (id) references actor(id) on delete > cascade on update cascade; > > > create table person_profile ( > person_id integer not null, > primary key(person_id) > ); > > alter table person_profile > add constraint fk_person_profile_person foreign key (person_id) references > person(id) on delete cascade on update cascade; > > CREATE TRIGGER manage_person BEFORE INSERT OR UPDATE OR DELETE ON person > FOR EACH ROW EXECUTE PROCEDURE manage_actor(); > > CREATE TABLE person_password_reset ( > person_id integer NOT NULL, > code varchar(32) NOT NULL, > create_time timestamp NOT NULL, > update_time timestamp DEFAULT NULL, > PRIMARY KEY (person_id) > ); > > alter table person_password_reset > add constraint fk_person_password_reset_person foreign key (person_id) > references person(id) on delete cascade on update cascade; > > CREATE TABLE contact_group ( > id serial, > person_id integer NOT NULL, > name varchar(255) not null, > create_time timestamp NOT NULL, > update_time timestamp default NULL, > PRIMARY KEY (id), > UNIQUE (person_id,name) > ); > > alter table contact_group > add constraint fk_contact_group_person foreign key (person_id) references > person(id) on delete cascade on update cascade; > > CREATE TABLE contact ( > id serial, > person_id integer NOT NULL, > person2_id integer NOT NULL, > status smallint not null, > create_time timestamp NOT NULL, > PRIMARY KEY (id), > UNIQUE (person_id,person2_id) > ); > > alter table contact > add constraint fk_contact_person foreign key (person_id) references > person(id) on delete cascade on update cascade, > add constraint fk_contact_person2 foreign key (person2_id) references > person(id) on delete cascade on update cascade; > > CREATE TABLE contact_group_contact ( > contact_group_id integer NOT NULL, > contact_id integer not null, > PRIMARY KEY (contact_group_id, contact_id) > ); > > alter table contact_group_contact > add constraint fk_contact_group_contact_contact foreign key (contact_id) > references contact(id) on delete cascade on update cascade, > add constraint fk_contact_group_contact_contact_group foreign key > (contact_group_id) references contact_group(id) on delete cascade on update > cascade; > > I am using postgresql 9.0.3 > > Generating entities works on a simpler database structure i tested it with, > but for some reason, it chokes with this 1. > > -- > If you want to report a vulnerability issue on symfony, please send it to > security at symfony-project.com > > You received this message because you are subscribed to the Google > Groups "symfony developers" group. > To post to this group, send email to symfony-devs@googlegroups.com > To unsubscribe from this group, send email to > symfony-devs+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/symfony-devs?hl=en > -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony developers" group. To post to this group, send email to symfony-devs@googlegroups.com To unsubscribe from this group, send email to symfony-devs+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-devs?hl=en
