View Single Post

   
  #2 (permalink)  
Old 04-24-2008, 06:15 PM
Craig Ringer
 
Posts: n/a
Default Re: Creating a sequence


> 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

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

Reply With Quote