Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating a sequence - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: Creating a sequence
Date
Msg-id 480F4FF6.9060908@postnewspapers.com.au
Whole thread Raw
In response to Re: Creating a sequence  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-jdbc
Tree view 
> 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

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Creating a sequence
Next
From: Tom Lane
Date:
Subject: Re: Query parameters limit in postgres jdbc driver?