Re: Creating a sequence

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Creating a sequence
Date: 2008-04-23 15:04:22
Message-ID: 480F4FF6.9060908@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


> 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Chris 2008-04-23 16:01:42 Login Roles
Previous Message Craig Ringer 2008-04-23 15:00:44 Re: Creating a sequence