From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
---|---|
To: | Indira Muthuswamy <indumuthu(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Bug? |
Date: | 2006-10-19 16:50:15 |
Message-ID: | 20061019165015.GH71084@nasby.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
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(at)nasby(dot)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(at)nasby(dot)net
> >EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
> >
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2006-10-19 17:27:27 | Adminpack build fix |
Previous Message | Jim C. Nasby | 2006-10-19 16:25:35 | Re: Additional stats for Relations |
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-10-19 16:55:29 | Re: Grouping by day, limiting amounts |
Previous Message | Woody Woodring | 2006-10-19 14:45:26 | Re: Grouping by day, limiting amounts |