> ALTER TABLE employee ALTER COLUMN emp_uid> DEFAULT nextval('employee_emp_uid_seq');
Er, that should've been: ... emp_uid SET DEFAULT ...not just: .... emp_uid DEFAULT ...
Sorry. I'm always doing that.
--Craig Ringer