Tried, everything works. Awesome! Ignas
On Sun, May 20, 2012 at 2:34 AM, Michael Bayer <mike...@zzzcomputing.com> wrote: > thanks. try r896d404af747. > > > On May 19, 2012, at 12:09 PM, Ignas Mikalajunas wrote: > >> CREATE TABLE users ( >> id bigserial NOT NULL, >> primary key (id) >> ); >> >> CREATE TABLE wall_posts ( >> id bigserial not null, >> user_id integer, >> foreign key (user_id) references users on delete cascade, >> primary key (id) >> );; >> >> CREATE TABLE wall_post_stars ( >> wall_post_id integer NOT NULL, >> user_id integer NOT NULL, >> foreign key (wall_post_id) references wall_posts on delete cascade, >> foreign key (user_id) references users on delete cascade, >> primary key (user_id, wall_post_id) >> ); >> >> >> On Sat, May 19, 2012 at 3:41 PM, Michael Bayer <mike...@zzzcomputing.com> >> wrote: >>> What's the fk setup there, do you have an FK column that is also a PK? >>> >>> Sent from my iPhone >>> >>> On May 19, 2012, at 7:24 AM, Ignas Mikalajunas >>> <ignas.mikalaju...@gmail.com> wrote: >>> >>>> Hi, >>>> >>>>>> A stack trace here would be extremely helpful. >>>> >>>> sorry forgot the error message for the traceback: >>>> >>>> NoReferencedColumnError: Could not create ForeignKey 'wall_posts.id' >>>> on table 'wall_post_stars': table 'wall_posts' has no column named >>>> 'id' >>>> >>>> Ignas >>>> >>>> -- >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> To unsubscribe from this group, send email to >> sqlalchemy+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/sqlalchemy?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.