OK, I before any starts on my about backups...I have one a week
old, but I want to fix this the right way! (and I want this past
week's worth of data.
What happened:
o downloaded ip and macaddr type programs written by Paul Vixie
et al., scrapped the ip stuff, and compiled the macaddr stuff.
R
>Timothy, Tom:
>
>> >1. a. Create new record with new key value in hosts table with the
>> >desired value
>> > b. Update the routes record to reference the new value
>> > c. Delete the old record in the hosts table
>> >
>>
>> Yes, that's what I tried.
>>
>> 1. foo.old.com exists in "hosts" t
DB: Postgresql 7.0.2
OS: Solaris 2.6
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.
I'm working on a project and using postgres 7.0.2
with phpPgAdmin and php3.0.16. Anyhow, the more
I learn about relations database systems, the more
orthogonal my data becomes. However, I then need
to have read/write views so that "ordinary" humans
can make sense of the data
While, I'm
