| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Timothy Covell <dirac(at)applink(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] Foreign Keys Help Delete! |
| Date: | 2000-09-20 00:37:22 |
| Message-ID: | Pine.BSF.4.10.10009191732080.54561-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Tue, 19 Sep 2000, Timothy Covell wrote:
> Schema:
> hosts table with fqhn column
> routes table with fqhn foreign key hosts(fqhn)
>
> Problem:
>
> 1. When I try to change fqhn in hosts, it complains that
> I have now violated entry in "routes" table.
>
> 2. When I try to update "routes" table, it updates.
>
> 3. Go back to "hosts" table and now try to rename/delete
> old fqhn and it complains about object missing with OID=xxxxx.
Can you give the table structure and statements you were
doing specifically?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jie Liang | 2000-09-20 01:19:43 | Re: [GENERAL] Foreign Keys Help Delete! |
| Previous Message | Josh Berkus | 2000-09-20 00:08:27 | Re: [GENERAL] Foreign Keys Help Delete! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jie Liang | 2000-09-20 01:19:43 | Re: [GENERAL] Foreign Keys Help Delete! |
| Previous Message | Josh Berkus | 2000-09-20 00:08:27 | Re: [GENERAL] Foreign Keys Help Delete! |