Working on a PostgreSQL database with over a thousand records from late eighteenth-century exhibition catalogues of the Royal Academy, I discover I cannot alter the attributes of a column once it’s already been created.

WTF?

It’s true. You have to backup all the data, recreate the table from scratch with the column attributes you want, and then reload your backup.

At least that’s what you have to do with version 6.5.2 of PostgreSQL. It’s possible later versions allow you to do something simpler.

Just a techno-geek entry, dear reader, to bolster my street-cred with the computing crowd. ;-)

Update: On second thought, maybe the fact that I didn’t already know this does nothing for my credibility. Hmm.

A mid-day walk through the neighborhood. While we’ve had an unseasonably warm fall, it has finally turned cold. Overcast, and there’s a bit of precipitation, too. I used to hate weather like this, but now I long for days like today.

Upside: There’s a coffee processing plant in my neighborhood. The air smells good.
Downside: It’s Folger’s coffee.
Upside, part ii: There’s a good coffee shop in “Scamp’s Alley” (check out the last pair of photos in this entry from Heidi) where I can get a decent cafe americano.