[SQL] nevermind...

2000-07-14 Thread John BEPPU
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

[SQL] case-sensitivity and the serial type

2000-07-14 Thread John BEPPU
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.