From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | "David Boesch" <davidboesch(at)datasc(dot)com(dot)au> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #3417: Foreign key constraint violation occurs unexpectedly |
Date: | 2007-06-28 12:48:40 |
Message-ID: | 87ejjwgs7r.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"David Boesch" <davidboesch(at)datasc(dot)com(dot)au> writes:
> I add data to reference
>
> select * from reference shows as
>
> id | name | description
> ----+----------------+--------------------------------
> 11 | rd | road
> 12 | st | street
> 13 | way | way
> 14 | close | close
> 15 | bend | bend
> 3 | vic | victoria
> 4 | nsw | new south wales
> 5 | qld | queensland
> 6 | nt | northern territory
> 7 | sa | south australia
How did you add this data? Given that the ids are out of order I assume you've
updated or deleted and re-inserted records a few times? That shouldn't break
anything but it's possible the insert on table a doesn't see the same version
of this table that you're looking at with the select.
Also, just to check that there's nothing wrong with the inex, what do you get
if you do:
enable_seqscan = off;
select * from reference where id = 7;
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-06-28 16:34:03 | Re: BUG #3415: plperl spi_exec_prepared variable undef value confusion |
Previous Message | David Boesch | 2007-06-28 12:19:13 | BUG #3417: Foreign key constraint violation occurs unexpectedly |