Re: intiial sql and foreign keys

2013-12-14 Thread Larry Martell
On Sat, Dec 14, 2013 at 12:22 PM, Tom Lockhart wrote: > Ah, hadn't used that before. And frankly I wouldn't bother doing that > since it is a one-time operation. I would write a script to do the load > with calls to psql (assuming you are using postgres of course). If order is > not guaranteed the

Re: intiial sql and foreign keys

2013-12-14 Thread Tom Lockhart
Ah, hadn't used that before. And frankly I wouldn't bother doing that since it is a one-time operation. I would write a script to do the load with calls to psql (assuming you are using postgres of course). If order is not guaranteed then even if things work for you now using "initial sql" may ju

Re: intiial sql and foreign keys

2013-12-14 Thread Larry Martell
On Fri, Dec 13, 2013 at 8:08 PM, Tom Lockhart wrote: > > On 2013-12-13, at 1:48 PM, Larry Martell wrote: > > I have 2 tables that I need to initialize with some initial sql files. > One table has a foreign key reference into the other. The docs say > "Note that if you have multiple SQL data files

Re: intiial sql and foreign keys

2013-12-13 Thread Tom Lockhart
On 2013-12-13, at 1:48 PM, Larry Martell wrote: > I have 2 tables that I need to initialize with some initial sql files. > One table has a foreign key reference into the other. The docs say > "Note that if you have multiple SQL data files, there’s no guarantee > of the order in which they’re exe

intiial sql and foreign keys

2013-12-13 Thread Larry Martell
I have 2 tables that I need to initialize with some initial sql files. One table has a foreign key reference into the other. The docs say "Note that if you have multiple SQL data files, there’s no guarantee of the order in which they’re executed." So what can I do here? I obviously need the table w