Reset sequence number

Поиск
Список
Период
Сортировка
Искать

Reset sequence number

От:
Marc <syn_uw@nospan_hotmail.com>
Дата:
Hello,

How can I reset a sequence number back to 0 ?

Regards


Re: Reset sequence number

От:
missive@frontiernet.net (Lee Harr)
Дата:
> How can I reset a sequence number back to 0 ?
> 

SELECT setval('sequence_name', 0);


In order for this to work, the sequence must have been created with
a MINVALUE of 0 (the default MINVALUE is 1)

CREATE SEQUENCE sequence_name MINVALUE 0;

Re: Reset sequence number

От:
Bruno Wolff III <bruno@wolff.to>
Дата:
On Sat, Feb 23, 2002 at 05:07:34PM +0000,
  Lee Harr  wrote:
> > How can I reset a sequence number back to 0 ?
> > 
> 
> SELECT setval('sequence_name', 0);
> 
> 
> In order for this to work, the sequence must have been created with
> a MINVALUE of 0 (the default MINVALUE is 1)
> 
> CREATE SEQUENCE sequence_name MINVALUE 0;

Note, that if you do it this way, 1 will be the next sequent number returned
by nextval. If you want 0 to be returned next use setval('seq_name', 0, false).

Re: Reset sequence number

От:
"Lonh SENG" <slonh@camgsm.com.kh>
Дата:
I use truncate table $table_name.
This will delete all data from that table and reset the sequense number.
----- Original Message ----- 
From: "Marc" 
To: 
Sent: Saturday, February 23, 2002 6:37 PM
Subject: [ADMIN] Reset sequence number


> Hello,
> 
> How can I reset a sequence number back to 0 ?
> 
> Regards
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

FAQ