What you say makes sense - I must have been doing something screwy because it works fine now. --Joe On Sun, 2004-04-04 at 00:44, Tom Lane wrote: > Joe Stump <joe@joestump.net> writes: > > I was getting an error on the parentID reference because there were no > > records to reference in the first place. Odd. > > It should work, because the FK check is an end-of-statement check and > should consider the just-inserted row as available for referencing. > What PG version are you using, and can you show the exact sequence of > operations that produces a failure for you? > > regards, tom lane -- -- Joe Stump, President JCS Solutions p. (734) 786 0176 f. (520) 844 9344 http://www.jcssolutions.com ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
