Nevermind my last post. I'm still confused, but for
different reasons. I'm on my friends box, and I have
screen running. In one tty, creating tables with the
serial type works, but in the other tty, it fails.
Both shells are on the same box, so it must be some
kind of environment issue (or that
I've been using the debian package of postgresql (7.0-release-1)
and I've been able to say something like:
create table blah ( id serial );
Note how serial is all lowercase. I have since compiled
postgresql 7.0.2 on my friends box and installed it in my
home directory so I could play w/ it.