subject:"\[SQL\] reset sequence"

Re: [SQL] reset sequence

2002-09-12 Thread Michael Paesold

Ludwig Lim wrote: > --- Ricardo Javier Aranibar León > <[EMAIL PROTECTED]> wrote: > > Hi List, > > > > I need that somebody help me. > > First, I use PostgreSQL 7.0.3 for linux. > > I need reset my sequence but that it begin in 1 > > again when a use nextval. > > And I have been search in > > htt

Re: [SQL] reset sequence

2002-09-12 Thread Ludwig Lim

--- Ricardo Javier Aranibar León <[EMAIL PROTECTED]> wrote: > Hi List, > > I need that somebody help me. > First, I use PostgreSQL 7.0.3 for linux. > I need reset my sequence but that it begin in 1 > again when a use nextval. > And I have been search in > http://archives.postgresql.org/ about re

[SQL] reset sequence

2002-09-11 Thread Ricardo Javier Aranibar León

Hi List, I need that somebody help me. First, I use PostgreSQL 7.0.3 for linux. I need reset my sequence but that it begin in 1 again when a use nextval. And I have been search in http://archives.postgresql.org/ about reset sequence but I obtain this information: SELECT setval('name_sequence'