Re: [RDBO] add_relationship(soft => 1)

2006-08-05 Thread John Siracusa
On 8/5/06 7:36 PM, Danial Pearce wrote: > On 8/2/06, John Siracusa <[EMAIL PROTECTED]> wrote: >> On 8/1/06 6:43 PM, Danial Pearce wrote: >>> create table foo ( >>> id serial not null, >>> foo text, >>> primary key (id) >>> ); >>> >>> create table bar ( >>> foo_id int references

Re: [RDBO] add_relationship(soft => 1)

2006-08-05 Thread Danial Pearce
On 8/2/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 8/1/06 6:43 PM, Danial Pearce wrote: > > create table foo ( > > id serial not null, > > foo text, > > primary key (id) > > ); > > > > create table bar ( > > foo_id int references foo(id), > > bar text, > > primar

Re: [RDBO] add_relationship(soft => 1)

2006-08-05 Thread Danial Pearce
> > create table foo ( id serial not null, foo text ); > > create table bar ( foo_id int not null references foo(id), bar text); > > Neither has a primary key, and RDBO requires every table to have one. But > I'll assume you meant this: > > create table foos > ( > id serial not null primar

Re: [RDBO] add_relationship(soft => 1)

2006-08-05 Thread John Siracusa
(Oops, accidentally sent an imcomplete message last time On 8/5/06 9:44 AM, Danial Pearce wrote: > On 8/5/06, John Siracusa <[EMAIL PROTECTED]> wrote: >> I've rearranged the interface to this stuff a little bit in SVN, but >> the results should still take care of your situation. If you get a >> ch

Re: [RDBO] add_relationship(soft => 1)

2006-08-05 Thread John Siracusa
On 8/5/06 1:12 PM, John Siracusa wrote: > [...] > Given those tables, this is what the Loader makes of them: > Oops, accidentally sent an incomplete message. Will resend the whole thing when I'm done with it :) -John - T

Re: [RDBO] add_relationship(soft => 1)

2006-08-05 Thread John Siracusa
On 8/5/06 9:44 AM, Danial Pearce wrote: > On 8/5/06, John Siracusa <[EMAIL PROTECTED]> wrote: >> I've rearranged the interface to this stuff a little bit in SVN, but >> the results should still take care of your situation. If you get a >> chance, try the SVN version and let me know if it correctly

Re: [RDBO] add_relationship(soft => 1)

2006-08-05 Thread Danial Pearce
On 8/5/06, John Siracusa <[EMAIL PROTECTED]> wrote: > I've rearranged the interface to this stuff a little bit in SVN, but > the results should still take care of your situation. If you get a > chance, try the SVN version and let me know if it correctly makes the > foo->bar relationship "optional"