Archives July 19, 2004
Redefining foreign keys, much easier than I thought (Accessing database over ssh w/ 10 network hops is *very* slow...)
Written by
on
in
Snaking.
For those who are interested in how to alter the ON DELETE/ON CASCADE features of a foreign key constraint. There's no need whatsoever to alter the system catalogs directly, I'd just missed the ALTER TABLE variant that drops constraints, namely "DROP CONSTRAINT".
Turns out that the drop commands are using the pg_depend table to decide ...
Dratted postgresql failures are getting in the way... (I know, I know, if I hadn't poked where I shouldn't have I wouldn't have this problem...)
Written by
on
in
Snaking.
On Friday I made the mistake of trying to add ON DELETE constraints to a number of foreign-key field references. I wrote a little script that went through and altered the PostgreSQL system tables trying to drop the foreign-key references and then re-generate them with ALTER TABLE. Unforunately, that script messed up by not taking ...
Firefox and Thunderbird switch... (Switched to fix broken spell-check, now it works in Mozilla but not Thunderbird)
Written by
on
in
Vindaloo.
While rebuilding Rosey's machine, I decided to see if I couldn't get Firefox and Thunderbird working on my machine. Problem I've been having is that there's nothing in the UI for the mail client (Thunderbird) for importing Mozilla 1.7 settings and messages (though there's lots for importing from other mail clients).
Anyway, it does appear ...
Previous day
Next day
Archives
Mike C. Fletcher, the VRPlumber, is a philosopher of design turned computer programmer based in Toronto, Canada. He works primarily in the Python programming language, and maintains a large number of Open Source software packages. You can reach him at: mcfletch@vrplumber.com.