|
|
|
|
|
|
| Author |
Message |
Greg Philpott
*nix forums beginner
Joined: 21 Jul 2006
Posts: 3
|
 Posted: Fri Jul 21, 2006 1:32 am Post subject:
setting serial start value
|
|
|
I have a table with a field called "id" that is a serial field and
pkey. I would like to set the the sequence to start at 10000 and
increase sequentially from there but I can't seem to get that to
work. any suggestions are greatly appreciated.
I am using version 7.4.7
Greg
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq |
|
| Back to top |
|
 |
Michael Fuhr
*nix forums Guru
Joined: 02 Mar 2005
Posts: 674
|
|
| Back to top |
|
|
Greg Philpott
*nix forums beginner
Joined: 21 Jul 2006
Posts: 3
|
| Posted: Fri Jul 21, 2006 3:35 am Post subject:
Re: setting serial start value
|
|
|
Hi Michael, from terminal in psql I enter
# ALTER SEQUENCE public.users MINVALUE 9999;
But it doesn't work. I don't think I am specifying the field
correctly. the schema is public, the table is users, the field is id.
Thanks,
Greg
On 20-Jul-06, at 10:49 PM, Michael Fuhr wrote:
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq |
|
| Back to top |
|
|
Michael Fuhr
*nix forums Guru
Joined: 02 Mar 2005
Posts: 674
|
| Posted: Fri Jul 21, 2006 4:05 am Post subject:
Re: setting serial start value
|
|
|
On Thu, Jul 20, 2006 at 11:35:51PM -0400, Greg Philpott wrote:
| Quote: | Hi Michael, from terminal in psql I enter
# ALTER SEQUENCE public.users MINVALUE 9999;
But it doesn't work. I don't think I am specifying the field
correctly. the schema is public, the table is users, the field is id.
|
ALTER SEQUENCE uses the sequence name, not the table name. Also,
use RESTART WITH to set the sequence's current value. Example:
test=> CREATE TABLE users (id serial PRIMARY KEY, username text);
NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for "serial" column "users.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
CREATE TABLE
test=> ALTER SEQUENCE users_id_seq RESTART WITH 10000;
ALTER SEQUENCE
test=> INSERT INTO users (username) VALUES ('Alice');
INSERT 2592322 1
test=> INSERT INTO users (username) VALUES ('Bob');
INSERT 2592323 1
test=> SELECT * FROM users;
id | username
-------+----------
10000 | Alice
10001 | Bob
(2 rows)
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq |
|
| Back to top |
|
|
Greg Philpott
*nix forums beginner
Joined: 21 Jul 2006
Posts: 3
|
| Posted: Fri Jul 21, 2006 4:26 am Post subject:
Re: setting serial start value
|
|
|
Thanks Michael that did the trick!
Greg
On 21-Jul-06, at 12:05 AM, Michael Fuhr wrote:
| Quote: | On Thu, Jul 20, 2006 at 11:35:51PM -0400, Greg Philpott wrote:
Hi Michael, from terminal in psql I enter
# ALTER SEQUENCE public.users MINVALUE 9999;
But it doesn't work. I don't think I am specifying the field
correctly. the schema is public, the table is users, the field is id.
ALTER SEQUENCE uses the sequence name, not the table name. Also,
use RESTART WITH to set the sequence's current value. Example:
test=> CREATE TABLE users (id serial PRIMARY KEY, username text);
NOTICE: CREATE TABLE will create implicit sequence "users_id_seq"
for "serial" column "users.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"users_pkey" for table "users"
CREATE TABLE
test=> ALTER SEQUENCE users_id_seq RESTART WITH 10000;
ALTER SEQUENCE
test=> INSERT INTO users (username) VALUES ('Alice');
INSERT 2592322 1
test=> INSERT INTO users (username) VALUES ('Bob');
INSERT 2592323 1
test=> SELECT * FROM users;
id | username
-------+----------
10000 | Alice
10001 | Bob
(2 rows)
--
Michael Fuhr
|
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Sun Nov 23, 2008 1:38 pm | All times are GMT
|
|
Mortgage Loans | Cheapest mobile phones | Advertising | Ringtone | Mortgage Calculator
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
PostgreSQL
