From: | "Indira Muthuswamy" <indumuthu(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Bug? |
Date: | 2006-10-18 13:23:46 |
Message-ID: | e1a645540610180623s2d3bf652k7fee992947a65903@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
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?
Thanks in advance,
Regards,
m.Indira
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-10-18 13:31:54 | Re: Bug? |
Previous Message | Csaba Nagy | 2006-10-18 13:16:56 | Re: bug or feature, || -operator and NULLs |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2006-10-18 13:31:54 | Re: Bug? |
Previous Message | chrisj | 2006-10-17 20:42:17 | Re: Assigning a timestamp without timezone to a timestamp |