| From: | Joe Stump <joe(at)joestump(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Recursive FOREIGN KEY? |
| Date: | 2004-04-04 04:46:50 |
| Message-ID: | 1081054009.18531.26.camel@lauren |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)joestump(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-04-04 05:44:13 | Re: Recursive FOREIGN KEY? |
| Previous Message | Tom Lane | 2004-04-04 04:36:48 | Re: Recursive FOREIGN KEY? |