From: Jim C. Nasby <jim@nasby.net>
To: Indira Muthuswamy <indumuthu@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Bug?
Date: Thu, 19 Oct 2006 11:50:15 -0500
Message-ID: <20061019165015.GH71084@nasby.net> (raw)
In-Reply-To: <e1a645540610182358n3468d7bv9f152a49c7e650@mail.gmail.com>
References: <e1a645540610180623s2d3bf652k7fee992947a65903@mail.gmail.com>
<20061018184346.GG85041@nasby.net>
<e1a645540610182358n3468d7bv9f152a49c7e650@mail.gmail.com>
See section 9.12 of the docs.
On Thu, Oct 19, 2006 at 12:28:58PM +0530, Indira Muthuswamy wrote:
> Then how do we clear the values of a serial column(is it done only by
> dropping the column?)?
>
> Regards,
> M.Indira
>
>
>
> On 10/19/06, Jim C. Nasby <jim@nasby.net> wrote:
> >
> >Moving to -sql.
> >
> >On Wed, Oct 18, 2006 at 06:53:46PM +0530, Indira Muthuswamy wrote:
> >> Hai,
> >>
> >> I have encountered a problem with PostgreSQL.I have created a table
> >> 'tab1' with a column 'a' with serial type.I entered 20 records into the
> >> table.So the query
> >> select max(a) from tab1;
> >> returned 20.When I tried the same query after the command
> >> truncate table tab1;
> >> I found that the output of the first query as
> >>
> >> max
> >> -----
> >>
> >> (1 row)
> >> When I tried to insert a new row into the table tab1 I found that the
> >> value at column a incremented to the value 21.
> >> But I heard from my friends that the value of the serial column gets
> >> decremented whenever we issue the 'truncate table' command (in MS SQL
> >> SERVER).Is the concept same with PostgreSQL or not?Can anyone clarify me
> >on
> >> this?
> >
> >Your friends are mistaken. TRUNCATE does nothing to affect sequences.
> >--
> >Jim Nasby jim@nasby.net
> >EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
> >
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jim@nasby.net, indumuthu@gmail.com
Subject: Re: [HACKERS] Bug?
In-Reply-To: <20061019165015.GH71084@nasby.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox